APPS.PAY_SE_INCOME_STATEMENT dependencies on HR_LOCATIONS

Line 391: csr_v_location_id hr_locations.location_id%TYPE

387:
388: l_legal_employer_details csr_legal_employer_details%ROWTYPE;
389:
390: CURSOR csr_address_details (
391: csr_v_location_id hr_locations.location_id%TYPE
392: )
393: IS
394: SELECT hl.location_code
395: ,hl.description

Line 405: ,hr_locations hl

401: ,hl.region_1
402: ,hl.region_2
403: ,ft.territory_short_name
404: FROM hr_organization_units hou
405: ,hr_locations hl
406: ,fnd_territories_vl ft
407: WHERE hl.location_id = csr_v_location_id
408: AND hl.country = ft.territory_code;
409: