APPS.ECE_TRADING_PARTNERS_PUB dependencies on HR_LOCATIONS_ALL_TL

Line 374: hr_locations_all_tl hrlt

370: hrl.region_2 region_2,
371: hrl.region_3 region_3,
372: TO_CHAR(hrl.inventory_organization_id) inv_organization_id --Bug 2570369
373: FROM hr_locations_all hrl,
374: hr_locations_all_tl hrlt
375: WHERE NVL(UPPER(hrl.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
376: NVL(UPPER(hrl.address_line_1),' ') LIKE NVL(UPPER(cp_address_line1_in),'%') AND
377: NVL(UPPER(hrl.address_line_2),' ') LIKE NVL(UPPER(cp_address_line2_in),'%') AND
378: NVL(UPPER(hrl.address_line_3),' ') LIKE NVL(UPPER(cp_address_line3_in),'%') AND