DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1732: from hr_all_organization_units_tl

1728: p_organization_id number) return varchar2 is
1729: --
1730: cursor csr_lookup is
1731: select name
1732: from hr_all_organization_units_tl
1733: where organization_id = p_organization_id
1734: and language = userenv('LANG');
1735: --
1736: v_meaning hr_all_organization_units_tl.name%TYPE := null;

Line 1736: v_meaning hr_all_organization_units_tl.name%TYPE := null;

1732: from hr_all_organization_units_tl
1733: where organization_id = p_organization_id
1734: and language = userenv('LANG');
1735: --
1736: v_meaning hr_all_organization_units_tl.name%TYPE := null;
1737: --
1738: begin
1739: --
1740: -- Only open the cursor if the parameter is going to retrieve anything