DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1730: from hr_all_organization_units_tl

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;

Line 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