APPS.PAY_DK_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 902: FROM hr_locations_all hla

898: ,hla.address_line_1 AL1
899: ,hla.address_line_2 AL2
900: ,hla.address_line_3 AL3
901: ,hla.postal_code postal_code
902: FROM hr_locations_all hla
903: ,hr_organization_units hou
904: WHERE hou.organization_id = p_organization_id
905: AND hou.location_id = hla.location_id;
906: -------------

Line 914: FROM hr_locations_all hla,

910: ,hla.address_line_2 AL2
911: ,hla.address_line_3 AL3
912: ,hla.country country
913: ,hla.postal_code postal_code
914: FROM hr_locations_all hla,
915: hr_organization_units hoa
916: WHERE hla.location_id = hoa.location_id
917: AND hoa.organization_id = p_organization_id
918: AND p_effective_date BETWEEN hoa.date_from AND NVL(hoa.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 985: FROM hr_locations_all

981: -------------
982: /* Cursor to pick up Payroll Location */
983: CURSOR csr_pay_location(p_location_id NUMBER) IS
984: SELECT location_code location
985: FROM hr_locations_all
986: WHERE location_id = p_location_id;
987: -------------
988: /* Cursor to pick Hire Date*/
989: CURSOR csr_hire_date (p_assignment_id NUMBER) IS

Line 1059: l_pay_location hr_locations_all.address_line_1%TYPE;

1055: l_hire_date per_periods_of_service.date_start%TYPE;
1056: l_grade per_grades.name%TYPE;
1057: l_currency hr_organization_information.org_information10%TYPE;
1058: l_organization hr_organization_units.name%TYPE;
1059: l_pay_location hr_locations_all.address_line_1%TYPE;
1060: l_postal_code VARCHAR2(80);
1061: l_country VARCHAR2(30);
1062: l_emp_postal_code VARCHAR2(80);
1063: l_emp_country VARCHAR2(30);