APPS.PAY_KW_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 926: FROM per_org_structure_elements pose

922:
923: /* Cursor to retrieve top most organization in the hierarchy */
924: CURSOR csr_top_org(p_org_structure_version_id NUMBER) IS
925: SELECT DISTINCT pose.organization_id_parent
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 = p_org_structure_version_id);

Line 929: FROM per_org_structure_elements pose1

925: SELECT DISTINCT pose.organization_id_parent
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 = p_org_structure_version_id);
931:
932: /* Cursor to retrieve Business Group Id */
933: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS

Line 999: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;

995: l_person_id NUMBER;
996: l_bg_id NUMBER;
997: l_employer_name hr_organization_units.name%TYPE;
998: l_org_struct_ver_id hr_organization_information.org_information1%TYPE;
999: l_top_org_id per_org_structure_elements.organization_id_parent%TYPE;
1000: l_cost_center pay_cost_allocations_v.concatenated_segments%TYPE;
1001: l_defined_balance_id NUMBER;
1002: l_balance_value NUMBER;
1003: l_defined_balance_id_ded NUMBER;