APPS.HR_DE_ORG_INFO dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 24: FROM per_org_structure_elements

20: WHERE p_org_exists_in_hierarchy = 'Y'
21: UNION
22: SELECT organization_id_parent
23: ,level lev
24: FROM per_org_structure_elements
25: WHERE org_structure_version_id = p_org_structure_version_id
26: START WITH organization_id_child = p_org_id
27: CONNECT BY PRIOR organization_id_parent = organization_id_child
28: AND org_structure_version_id = p_org_structure_version_id

Line 39: FROM per_org_structure_elements

35: WHERE p_org_exists_in_hierarchy = 'Y'
36: UNION
37: SELECT organization_id_parent
38: ,level lev
39: FROM per_org_structure_elements
40: WHERE org_structure_version_id = p_org_structure_version_id
41: START WITH organization_id_child = p_org_id
42: CONNECT BY PRIOR organization_id_parent = organization_id_child
43: AND org_structure_version_id = p_org_structure_version_id

Line 132: FROM per_org_structure_elements se

128: -- Cursor to see if the organization belongs to the current named hierarchy.
129: --
130: CURSOR c_org_exists(p_organization_id NUMBER, p_org_structure_version_id NUMBER) IS
131: SELECT se.organization_id_child
132: FROM per_org_structure_elements se
133: WHERE se.org_structure_version_id = p_org_structure_version_id
134: AND (se.organization_id_parent = p_organization_id OR
135: se.organization_id_child = p_organization_id);
136: --