APPS.MSC_IMPORT_UTIL dependencies on MSC_TRADING_PARTNER_SITES

Line 416: from msc_trading_partner_sites

412: sr_instance_id = l_sr_instance_id;
413:
414: cursor c_get_cust_site_id (l_cust_id number,l_sr_instance_id number,l_tp_site_code varchar2) is
415: select partner_site_id --sr_tp_site_id
416: from msc_trading_partner_sites
417: where partner_id=l_cust_id and
418: location= l_tp_site_code and
419: tp_site_code='SHIP_TO' and
420: sr_instance_id = l_sr_instance_id;