APPS.HR_NL_ORG_INFO dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 18: FROM per_org_structure_elements

14: ,level
15: FROM
16: (SELECT organization_id_parent
17: ,organization_id_child
18: FROM per_org_structure_elements
19: WHERE org_structure_version_id = latest_named_hierarchy_vers(p_org_id)
20: )
21: START WITH organization_id_child = p_org_id
22: CONNECT BY PRIOR organization_id_parent = organization_id_child

Line 126: FROM per_org_structure_elements se

122: -- named hierarchy.
123: --
124: CURSOR c_org_exists(vp_organization_id NUMBER) IS
125: SELECT se.organization_id_child
126: FROM per_org_structure_elements se
127: WHERE se.org_structure_version_id =
128: latest_named_hierarchy_vers(vp_organization_id)
129: AND (se.organization_id_parent = vp_organization_id OR
130: se.organization_id_child = vp_organization_id);

Line 288: FROM per_org_structure_elements

284: FROM
285: (
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

Line 876: FROM per_org_structure_elements pose

872: SELECT distinct organization_id_parent
873: ,level
874: FROM (
875: SELECT distinct organization_id_parent, organization_id_child
876: FROM per_org_structure_elements pose
877: where pose.org_structure_version_id = l_org_struct_version_id)
878: START WITH organization_id_child = l_org_id
879: CONNECT BY PRIOR organization_id_parent = organization_id_child)
880: where

Line 1473: from per_org_structure_elements pose,hr_organization_information e

1469: return varchar2 is
1470:
1471: cursor c_all_emp is
1472: select pose.organization_id_child employer
1473: from per_org_structure_elements pose,hr_organization_information e
1474: where 1=1 --pose.org_structure_version_id = P_Org_Struct_Version_Id --16275108
1475: and e.organization_id=pose.organization_id_child
1476: and ((e.org_information_context= 'NL_ORG_INFORMATION'
1477: and e.org_information3 IS NOT NULL

Line 2183: FROM per_org_structure_elements pose

2179: SELECT l_org_id iza_org_id,0 lev from dual
2180: UNION
2181: SELECT distinct organization_id_parent
2182: ,level
2183: FROM per_org_structure_elements pose
2184: where pose.org_structure_version_id = l_org_struct_version_id
2185: START WITH organization_id_child = l_org_id
2186: CONNECT BY PRIOR organization_id_parent = organization_id_child)
2187: where