APPS.PAY_SA_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 912: FROM per_org_structure_elements pose

908:
909: /* Cursor to retrieve top most organization in the hierarchy */
910: CURSOR csr_top_org(p_org_structure_version_id NUMBER) IS
911: SELECT DISTINCT pose.organization_id_parent
912: FROM per_org_structure_elements pose
913: WHERE pose.org_structure_version_id = p_org_structure_version_id
914: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
915: FROM per_org_structure_elements pose1
916: WHERE pose1.org_structure_version_id = p_org_structure_version_id);

Line 915: FROM per_org_structure_elements pose1

911: SELECT DISTINCT pose.organization_id_parent
912: FROM per_org_structure_elements pose
913: WHERE pose.org_structure_version_id = p_org_structure_version_id
914: AND pose.organization_id_parent NOT IN (SELECT pose1.organization_id_child
915: FROM per_org_structure_elements pose1
916: WHERE pose1.org_structure_version_id = p_org_structure_version_id);
917:
918: /* Cursor to retrieve Business Group Id */
919: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS

Line 1018: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

1014: l_person_id NUMBER;
1015: l_bg_id NUMBER;
1016: l_employer_name hr_organization_units.name%TYPE;
1017: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1018: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1019: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1020: l_defined_balance_id NUMBER;
1021: l_balance_value NUMBER;
1022: l_formatted_value VARCHAR2(50) := NULL;