APPS.PAY_AE_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 895: FROM hr_locations_all hla

891: ,hla.address_line_1 AL1
892: ,hla.address_line_2 AL2
893: ,hla.address_line_3 AL3
894: ,hla.postal_code postal_code
895: FROM hr_locations_all hla
896: ,hr_organization_units hou
897: ,per_all_assignments_f paa
898: ,hr_soft_coding_keyflex hscl
899: WHERE hscl.segment1 = hou.organization_id

Line 918: FROM hr_locations_all hla,

914: ,hla.region_2 R2
915: ,hla.region_3 R3
916: ,hla.country country
917: ,hla.postal_code postal_code
918: FROM hr_locations_all hla,
919: hr_organization_units hoa
920: WHERE hla.location_id = hoa.location_id
921: AND hoa.organization_id = p_organization_id
922: AND p_effective_date BETWEEN hoa.date_from

Line 970: FROM hr_locations_all_tl

966:
967: /* Cursor to pick up Payroll Location */
968: CURSOR csr_pay_location(p_location_id NUMBER) IS
969: SELECT location_code location
970: FROM hr_locations_all_tl
971: WHERE location_id = p_location_id;
972:
973: /* Cursor to pick up Job */
974: CURSOR csr_job(p_job_id NUMBER) IS

Line 997: l_pay_location hr_locations_all.address_line_1%TYPE;

993: l_grade per_grades.name%TYPE;
994: l_job per_jobs.name%TYPE;
995: l_currency hr_organization_information.org_information10%TYPE;
996: l_organization hr_organization_units.name%TYPE;
997: l_pay_location hr_locations_all.address_line_1%TYPE;
998: l_city VARCHAR2(80);
999: l_country VARCHAR2(80);
1000: l_emp_city VARCHAR2(80);
1001: l_emp_country VARCHAR2(80);