APPS.PAY_SA_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 911: FROM per_org_structure_elements pose

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

Line 914: FROM per_org_structure_elements pose1

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

Line 1005: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

1001: l_person_id NUMBER;
1002: l_bg_id NUMBER;
1003: l_employer_name hr_organization_units.name%TYPE;
1004: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
1005: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1006: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1007: l_defined_balance_id NUMBER;
1008: l_balance_value NUMBER;
1009: l_formatted_value VARCHAR2(50) := NULL;