APPS.PAY_SA_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 877: FROM hr_locations_all hla

873: ,hla.address_line_1 AL1
874: ,hla.address_line_2 AL2
875: ,hla.address_line_3 AL3
876: ,hla.postal_code postal_code
877: FROM hr_locations_all hla
878: ,hr_organization_units hou
879: ,per_all_assignments_f paa
880: ,hr_soft_coding_keyflex hscl
881: WHERE hscl.segment1 = hou.organization_id

Line 900: FROM hr_locations_all hla,

896: ,hla.region_2 R2
897: ,hla.region_3 R3
898: ,hla.country country
899: ,hla.postal_code postal_code
900: FROM hr_locations_all hla,
901: hr_organization_units hoa
902: WHERE hla.location_id = hoa.location_id
903: AND hoa.organization_id = p_organization_id
904: AND p_effective_date BETWEEN hoa.date_from

Line 960: FROM hr_locations_all

956:
957: /* Cursor to pick up Payroll Location */
958: CURSOR csr_pay_location(p_location_id NUMBER) IS
959: SELECT location_code location
960: FROM hr_locations_all
961: WHERE location_id = p_location_id;
962:
963: /* Cursor to fetch lower limit of gosi base*/
964: CURSOR get_lower_base IS

Line 992: l_pay_location hr_locations_all.address_line_1%TYPE;

988: l_position per_all_positions.name%TYPE;
989: l_grade per_grades.name%TYPE;
990: l_currency hr_organization_information.org_information10%TYPE;
991: l_organization hr_organization_units.name%TYPE;
992: l_pay_location hr_locations_all.address_line_1%TYPE;
993: l_city VARCHAR2(80);
994: l_country VARCHAR2(80);
995: l_emp_city VARCHAR2(80);
996: l_emp_country VARCHAR2(80);