APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_LOCATIONS

Line 387: csr_v_location_id hr_locations.location_id%TYPE

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

Line 401: ,hr_locations hl

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