APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_LOCATIONS

Line 307: csr_v_location_id hr_locations.location_id%TYPE

303:
304: rg_csr_bg_get_defined_bal_id csr_bg_get_defined_balance_id%rowtype;
305:
306: CURSOR csr_address_details (
307: csr_v_location_id hr_locations.location_id%TYPE
308: )
309: IS
310: SELECT hl.location_code
311: ,hl.description

Line 321: ,hr_locations hl

317: ,hl.region_1
318: ,hl.region_2
319: ,ft.territory_short_name
320: FROM hr_organization_units hou
321: ,hr_locations hl
322: ,fnd_territories_vl ft
323: WHERE hl.location_id = csr_v_location_id
324: AND hl.country = ft.territory_code;
325: