APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_LOCATIONS

Line 385: csr_v_location_id hr_locations.location_id%TYPE

381: AND pat.absence_category NOT IN ('V')
382: ORDER BY paa.date_start;
383:
384: CURSOR csr_address_details (
385: csr_v_location_id hr_locations.location_id%TYPE
386: )
387: IS
388: SELECT hl.location_code
389: ,hl.description

Line 399: ,hr_locations hl

395: ,hl.region_1
396: ,hl.region_2
397: ,ft.territory_short_name
398: FROM hr_organization_units hou
399: ,hr_locations hl
400: ,fnd_territories_vl ft
401: WHERE hl.location_id = csr_v_location_id
402: AND hl.country = ft.territory_code;
403: