APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_LOCATIONS

Line 310: csr_v_location_id hr_locations.location_id%TYPE

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

Line 324: ,hr_locations hl

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