APPS.ECE_TRADING_PARTNERS_PUB dependencies on HR_LOCATIONS_ALL

Line 373: FROM hr_locations_all hrl,

369: hrl.region_1 region_1,
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

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

Line 1956: FROM hr_locations_all hrl

1952: x_country_out,
1953: x_region_1_out,
1954: x_region_2_out,
1955: x_region_3_out
1956: FROM hr_locations_all hrl
1957: WHERE hrl.location_id = p_address_id_in;
1958:
1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN