APPS.HR_SA_ORG_INFO dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 16: FROM per_org_structure_elements

12: WHERE p_org_exists_in_hierarchy = 'Y'
13: UNION
14: SELECT organization_id_parent
15: ,level lev
16: FROM per_org_structure_elements
17: WHERE org_structure_version_id = p_org_structure_version_id
18: START WITH organization_id_child = p_org_id
19: CONNECT BY PRIOR organization_id_parent = organization_id_child
20: AND org_structure_version_id = p_org_structure_version_id

Line 31: FROM per_org_structure_elements

27: WHERE p_org_exists_in_hierarchy = 'Y'
28: UNION
29: SELECT organization_id_parent
30: ,level lev
31: FROM per_org_structure_elements
32: WHERE org_structure_version_id = p_org_structure_version_id
33: START WITH organization_id_child = p_org_id
34: CONNECT BY PRIOR organization_id_parent = organization_id_child
35: AND org_structure_version_id = p_org_structure_version_id

Line 124: FROM per_org_structure_elements se

120: -- Cursor to see if the organization belongs to the current named hierarchy.
121: --
122: CURSOR c_org_exists(p_organization_id NUMBER, p_org_structure_version_id NUMBER) IS
123: SELECT se.organization_id_child
124: FROM per_org_structure_elements se
125: WHERE se.org_structure_version_id = p_org_structure_version_id
126: AND (se.organization_id_parent = p_organization_id OR
127: se.organization_id_child = p_organization_id);
128: --