CREATE OR REPLACE FUNCTION core.get_base_unit_id_by_unit_name(text)
RETURNS integer
LANGUAGE plpgsql
STABLE
AS $function$
DECLARE _unit_id integer;
BEGIN
_unit_id := core.get_unit_id_by_unit_name($1);
RETURN core.get_root_unit_id(_unit_id);
END
$function$