APPS.PAY_DK_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 893: FROM hr_locations_all hla

889: ,hla.address_line_1 AL1
890: ,hla.address_line_2 AL2
891: ,hla.address_line_3 AL3
892: ,hla.postal_code postal_code
893: FROM hr_locations_all hla
894: ,hr_organization_units hou
895: WHERE hou.organization_id = p_organization_id
896: AND hou.location_id = hla.location_id;
897: -------------

Line 905: FROM hr_locations_all hla,

901: ,hla.address_line_2 AL2
902: ,hla.address_line_3 AL3
903: ,hla.country country
904: ,hla.postal_code postal_code
905: FROM hr_locations_all hla,
906: hr_organization_units hoa
907: WHERE hla.location_id = hoa.location_id
908: AND hoa.organization_id = p_organization_id
909: AND p_effective_date BETWEEN hoa.date_from AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 976: FROM hr_locations_all

972: -------------
973: /* Cursor to pick up Payroll Location */
974: CURSOR csr_pay_location(p_location_id NUMBER) IS
975: SELECT location_code location
976: FROM hr_locations_all
977: WHERE location_id = p_location_id;
978: -------------
979: /* Cursor to pick Hire Date*/
980: CURSOR csr_hire_date (p_assignment_id NUMBER) IS

Line 1050: l_pay_location hr_locations_all.address_line_1%TYPE;

1046: l_hire_date per_periods_of_service.date_start%TYPE;
1047: l_grade per_grades.name%TYPE;
1048: l_currency hr_organization_information.org_information10%TYPE;
1049: l_organization hr_organization_units.name%TYPE;
1050: l_pay_location hr_locations_all.address_line_1%TYPE;
1051: l_postal_code VARCHAR2(80);
1052: l_country VARCHAR2(30);
1053: l_emp_postal_code VARCHAR2(80);
1054: l_emp_country VARCHAR2(30);