APPS.PAY_SA_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 879: ,hr_organization_units hou

875: ,hla.address_line_2 AL2
876: ,hla.address_line_3 AL3
877: ,hla.postal_code postal_code
878: FROM hr_locations_all hla
879: ,hr_organization_units hou
880: ,per_all_assignments_f paa
881: ,hr_soft_coding_keyflex hscl
882: WHERE hscl.segment1 = hou.organization_id
883: AND hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 902: hr_organization_units hoa

898: ,hla.region_3 R3
899: ,hla.country country
900: ,hla.postal_code postal_code
901: FROM hr_locations_all hla,
902: hr_organization_units hoa
903: WHERE hla.location_id = hoa.location_id
904: AND hoa.organization_id = p_organization_id
905: AND p_effective_date BETWEEN hoa.date_from
906: AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 921: FROM hr_organization_units

917:
918: /* Cursor to retrieve Business Group Id */
919: CURSOR csr_bus_grp_id(p_organization_id NUMBER) IS
920: SELECT business_group_id
921: FROM hr_organization_units
922: WHERE organization_id = p_organization_id;
923:
924: /* Cursor to retrieve Currency */
925: CURSOR csr_currency(p_bg_id NUMBER) IS

Line 1004: l_organization hr_organization_units.name%TYPE;

1000: /*l_position per_all_positions.name%TYPE; */
1001: l_position hr_all_positions_f.name%TYPE; -- modified for bug 10255223
1002: l_grade per_grades.name%TYPE;
1003: l_currency hr_organization_information.org_information10%TYPE;
1004: l_organization hr_organization_units.name%TYPE;
1005: l_pay_location hr_locations_all.address_line_1%TYPE;
1006: l_city VARCHAR2(80);
1007: l_country VARCHAR2(80);
1008: l_emp_city VARCHAR2(80);

Line 1016: l_employer_name hr_organization_units.name%TYPE;

1012: l_action_info_id NUMBER;
1013: l_ovn NUMBER;
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;

Line 1113: FROM hr_organization_units

1109: END IF;
1110:
1111:
1112: SELECT name INTO l_organization
1113: FROM hr_organization_units
1114: WHERE organization_id = rec_person_details.org_id;
1115:
1116: SELECT name INTO l_employer_name
1117: FROM hr_organization_units

Line 1117: FROM hr_organization_units

1113: FROM hr_organization_units
1114: WHERE organization_id = rec_person_details.org_id;
1115:
1116: SELECT name INTO l_employer_name
1117: FROM hr_organization_units
1118: WHERE organization_id = rec_employer_address.org_id;
1119:
1120: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1121: l_city := null;