APPS.INV_INVSTMVT_XMLP_PKG dependencies on HR_LOCATIONS_NO_JOIN

Line 1282: hr_locations_no_join hl,

1278: CP_TELEPHONE_NUMBER_1, CP_TELEPHONE_NUMBER_2,
1279: CP_CONTACT_PERSON_NAME, --CP_VAT_REGISTRATION_NUMBER,
1280: CP_SET_OF_BOOKS_NAME
1281: FROM
1282: hr_locations_no_join hl,
1283: per_people_f ppf,
1284: gl_ledger_le_v gllv
1285: WHERE gllv.legal_entity_id = P_LEGAL_ENTITY_ID
1286: AND gllv.ledger_category_code = 'PRIMARY'

Line 1355: hr_locations_no_join

1351: CP_TAX_OFFICE_ADDRESS_LINE_1
1352: , CP_TAX_OFFICE_ADDRESS_LINE_2
1353: , CP_TAX_OFFICE_ADDRESS_LINE_3
1354: FROM
1355: hr_locations_no_join
1356: WHERE location_id = l_location_id;
1357:
1358: EXCEPTION
1359: WHEN NO_DATA_FOUND THEN