APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 1317: FROM hr_locations_all hla

1313: ,hla.address_line_1 AL1
1314: ,hla.address_line_2 AL2
1315: ,hla.address_line_3 AL3
1316: ,hla.postal_code postal_code
1317: FROM hr_locations_all hla
1318: ,hr_organization_units hou
1319: WHERE hou.organization_id = p_organization_id
1320: AND hou.location_id = hla.location_id;
1321: -------------

Line 1329: FROM hr_locations_all hla,

1325: ,hla.address_line_2 AL2
1326: ,hla.address_line_3 AL3
1327: ,hla.country country
1328: ,hla.postal_code postal_code
1329: FROM hr_locations_all hla,
1330: hr_organization_units hoa
1331: WHERE hla.location_id = hoa.location_id
1332: AND hoa.organization_id = p_organization_id
1333: AND p_effective_date BETWEEN hoa.date_from AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 1401: FROM hr_locations_all

1397: -------------
1398: /* Cursor to pick up Payroll Location */
1399: CURSOR csr_pay_location(p_location_id NUMBER) IS
1400: SELECT location_code location
1401: FROM hr_locations_all
1402: WHERE location_id = p_location_id;
1403: -------------
1404: /* Cursor to pick Hire Date*/
1405: CURSOR csr_hire_date (p_assignment_id NUMBER) IS

Line 1470: l_pay_location hr_locations_all.address_line_1%TYPE;

1466: l_hire_date per_periods_of_service.date_start%TYPE;
1467: l_grade per_grades.name%TYPE;
1468: l_currency hr_organization_information.org_information10%TYPE;
1469: l_organization hr_organization_units.name%TYPE;
1470: l_pay_location hr_locations_all.address_line_1%TYPE;
1471: l_postal_code VARCHAR2(80);
1472: l_country VARCHAR2(30);
1473: l_emp_postal_code VARCHAR2(80);
1474: l_emp_country VARCHAR2(30);