APPS.HR_NL_ORG_INFO dependencies on HR_NL_ORG_INFO

Line 1: PACKAGE BODY HR_NL_ORG_INFO AS

1: PACKAGE BODY HR_NL_ORG_INFO AS
2: /* $Header: penlorgi.pkb 120.5 2007/03/12 15:19:30 summohan ship $ */
3: g_package varchar2(33) := ' HR_NL_ORG_INFO.';
4: --
5: --

Line 3: g_package varchar2(33) := ' HR_NL_ORG_INFO.';

1: PACKAGE BODY HR_NL_ORG_INFO AS
2: /* $Header: penlorgi.pkb 120.5 2007/03/12 15:19:30 summohan ship $ */
3: g_package varchar2(33) := ' HR_NL_ORG_INFO.';
4: --
5: --
6: --Cursor which fetches Organizations from the named hierarchy-bottom to top
7: --

Line 290: hr_nl_org_info.latest_named_hierarchy_vers(vp_Organization_ID)

286: SELECT organization_id_parent
287: ,organization_id_child
288: FROM per_org_structure_elements
289: WHERE org_structure_version_id =
290: hr_nl_org_info.latest_named_hierarchy_vers(vp_Organization_ID)
291: )
292: START WITH organization_id_child= vp_Organization_ID
293: CONNECT BY PRIOR organization_id_parent= organization_id_child
294: ORDER BY lev;

Line 2232: END HR_NL_ORG_INFO;

2228:
2229:
2230:
2231:
2232: END HR_NL_ORG_INFO;