DBA Data[Home] [Help]

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.12020000.4 2013/02/04 10:11:59 mkuppuch 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.12020000.4 2013/02/04 10:11:59 mkuppuch 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 2503: END HR_NL_ORG_INFO;

2499:
2500: END get_b_rule_separate_run;
2501:
2502:
2503: END HR_NL_ORG_INFO;