APPS.PER_AE_XDO_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 28: FROM per_org_structure_elements pose

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

Line 125: FROM per_org_structure_elements pose

121: AND 1 IS NULL THEN
122: BEGIN
123: SELECT distinct pose.organization_id_parent
124: INTO l_parent_id
125: FROM per_org_structure_elements pose
126: WHERE pose.org_structure_version_id = p_org_structure_version_id
127: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
128: FROM per_org_structure_elements pose1
129: WHERE pose1.org_structure_version_id

Line 128: FROM per_org_structure_elements pose1

124: INTO l_parent_id
125: FROM per_org_structure_elements pose
126: WHERE pose.org_structure_version_id = p_org_structure_version_id
127: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
128: FROM per_org_structure_elements pose1
129: WHERE pose1.org_structure_version_id
130: = p_org_structure_version_id);
131: EXCEPTION
132: WHEN OTHERS THEN

Line 406: FROM per_org_structure_elements pose

402: SELECT org.organization_id
403: ,org.name
404: FROM hr_all_organization_units org
405: WHERE org.organization_id IN (SELECT pose.organization_id_child
406: FROM per_org_structure_elements pose
407: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child
408: AND pose.org_structure_version_id = p_org_structure_version_id
409: START WITH pose.organization_id_parent = nvl(c_business_group_id, l_parent_id)
410: AND pose.org_structure_version_id = p_org_structure_version_id

Line 503: FROM per_org_structure_elements pose

499: AND 1 IS NULL THEN
500: BEGIN
501: SELECT distinct pose.organization_id_parent
502: INTO l_parent_id
503: FROM per_org_structure_elements pose
504: WHERE pose.org_structure_version_id = p_org_structure_version_id
505: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
506: FROM per_org_structure_elements pose1
507: WHERE pose1.org_structure_version_id

Line 506: FROM per_org_structure_elements pose1

502: INTO l_parent_id
503: FROM per_org_structure_elements pose
504: WHERE pose.org_structure_version_id = p_org_structure_version_id
505: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
506: FROM per_org_structure_elements pose1
507: WHERE pose1.org_structure_version_id
508: = p_org_structure_version_id);
509: EXCEPTION
510: WHEN OTHERS THEN

Line 831: FROM per_org_structure_elements pose

827: SELECT org.organization_id
828: ,org.name
829: FROM hr_all_organization_units org
830: WHERE org.organization_id IN (SELECT pose.organization_id_child
831: FROM per_org_structure_elements pose
832: CONNECT BY pose.organization_id_parent = PRIOR pose.organization_id_child
833: AND pose.org_structure_version_id = p_org_structure_version_id
834: START WITH pose.organization_id_parent = nvl(p_org_id, l_parent_id)
835: AND pose.org_structure_version_id = p_org_structure_version_id

Line 926: FROM per_org_structure_elements pose

922: /*AND 1 IS NULL*/ THEN
923: BEGIN
924: SELECT distinct pose.organization_id_parent
925: INTO l_parent_id
926: FROM per_org_structure_elements pose
927: WHERE pose.org_structure_version_id = p_org_structure_version_id
928: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
929: FROM per_org_structure_elements pose1
930: WHERE pose1.org_structure_version_id

Line 929: FROM per_org_structure_elements pose1

925: INTO l_parent_id
926: FROM per_org_structure_elements pose
927: WHERE pose.org_structure_version_id = p_org_structure_version_id
928: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
929: FROM per_org_structure_elements pose1
930: WHERE pose1.org_structure_version_id
931: = p_org_structure_version_id);
932: EXCEPTION
933: WHEN OTHERS THEN