APPS.PAY_KW_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 892: FROM hr_locations_all hla

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

Line 915: FROM hr_locations_all hla,

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

Line 967: FROM hr_locations_all

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

Line 986: l_pay_location hr_locations_all.address_line_1%TYPE;

982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;
985: l_organization hr_organization_units.name%TYPE;
986: l_pay_location hr_locations_all.address_line_1%TYPE;
987: l_city VARCHAR2(80);
988: l_country VARCHAR2(80);
989: l_emp_city VARCHAR2(80);
990: l_emp_country VARCHAR2(80);