1726: p_organization_id number) return varchar2 is
1727: --
1728: cursor csr_lookup is
1729: select name
1730: from hr_all_organization_units_tl
1731: where organization_id = p_organization_id
1732: and language = userenv('LANG');
1733: --
1734: v_meaning hr_all_organization_units_tl.name%TYPE := null;
1730: from hr_all_organization_units_tl
1731: where organization_id = p_organization_id
1732: and language = userenv('LANG');
1733: --
1734: v_meaning hr_all_organization_units_tl.name%TYPE := null;
1735: --
1736: begin
1737: --
1738: -- Only open the cursor if the parameter is going to retrieve anything