APPS.INV_INVSTMVT_XMLP_PKG dependencies on HR_LOCATIONS_NO_JOIN

Line 1288: hr_locations_no_join hl,

1284: CP_TELEPHONE_NUMBER_1, CP_TELEPHONE_NUMBER_2,
1285: CP_CONTACT_PERSON_NAME, --CP_VAT_REGISTRATION_NUMBER,
1286: CP_SET_OF_BOOKS_NAME
1287: FROM
1288: hr_locations_no_join hl,
1289: per_people_f ppf,
1290: gl_ledger_le_v gllv
1291: WHERE gllv.legal_entity_id = P_LEGAL_ENTITY_ID
1292: AND gllv.ledger_category_code = 'PRIMARY'

Line 1361: hr_locations_no_join

1357: CP_TAX_OFFICE_ADDRESS_LINE_1
1358: , CP_TAX_OFFICE_ADDRESS_LINE_2
1359: , CP_TAX_OFFICE_ADDRESS_LINE_3
1360: FROM
1361: hr_locations_no_join
1362: WHERE location_id = l_location_id;
1363:
1364: EXCEPTION
1365: WHEN NO_DATA_FOUND THEN