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
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
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
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);