APPS.PER_KW_XDO_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 30: FROM per_org_structure_elements pose

26: ,org.name
27: FROM hr_all_organization_units org
28: ,hr_organization_information hoi
29: WHERE org.organization_id IN (SELECT pose.organization_id_child
30: FROM per_org_structure_elements pose
31: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child
32: AND pose.org_structure_version_id = p_org_structure_version_id
33: START WITH pose.organization_id_parent = nvl(p_legal_employer, l_parent_id)
34: AND pose.org_structure_version_id = p_org_structure_version_id

Line 159: FROM per_org_structure_elements pose

155: AND p_legal_employer IS NULL THEN
156: BEGIN
157: SELECT distinct pose.organization_id_parent
158: INTO l_parent_id
159: FROM per_org_structure_elements pose
160: WHERE pose.org_structure_version_id = p_org_structure_version_id
161: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
162: FROM per_org_structure_elements pose1
163: WHERE pose1.org_structure_version_id

Line 162: FROM per_org_structure_elements pose1

158: INTO l_parent_id
159: FROM per_org_structure_elements pose
160: WHERE pose.org_structure_version_id = p_org_structure_version_id
161: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
162: FROM per_org_structure_elements pose1
163: WHERE pose1.org_structure_version_id
164: = p_org_structure_version_id);
165: EXCEPTION
166: WHEN OTHERS THEN

Line 539: FROM per_org_structure_elements pose

535: ,org.name
536: FROM hr_all_organization_units org
537: ,hr_organization_information hoi
538: WHERE org.organization_id IN (SELECT pose.organization_id_child
539: FROM per_org_structure_elements pose
540: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child
541: AND pose.org_structure_version_id = p_org_structure_version_id
542: START WITH pose.organization_id_parent = nvl(p_legal_employer, l_parent_id)
543: AND pose.org_structure_version_id = p_org_structure_version_id

Line 655: FROM per_org_structure_elements pose

651: AND p_legal_employer IS NULL THEN
652: BEGIN
653: SELECT distinct pose.organization_id_parent
654: INTO l_parent_id
655: FROM per_org_structure_elements pose
656: WHERE pose.org_structure_version_id = p_org_structure_version_id
657: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
658: FROM per_org_structure_elements pose1
659: WHERE pose1.org_structure_version_id

Line 658: FROM per_org_structure_elements pose1

654: INTO l_parent_id
655: FROM per_org_structure_elements pose
656: WHERE pose.org_structure_version_id = p_org_structure_version_id
657: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
658: FROM per_org_structure_elements pose1
659: WHERE pose1.org_structure_version_id
660: = p_org_structure_version_id);
661: EXCEPTION
662: WHEN OTHERS THEN