DBA Data[Home] [Help]

APPS.MSC_IMPORT_UTIL dependencies on MSC_TRADING_PARTNERS

Line 393: from msc_trading_partners

389: plan_id = -1;
390:
391: cursor c_get_org_id(l_org_code varchar2) is
392: select sr_tp_id
393: from msc_trading_partners
394: where organization_code = l_org_code;
395:
396: cursor c_get_inst_id(l_inst_code varchar2) is
397: select instance_id

Line 409: from msc_trading_partners

405: sr_instance_id=l_sr_instance_id;
406:
407: cursor c_get_customer_id(l_cust_name varchar2,l_sr_instance_id number) is
408: select partner_id
409: from msc_trading_partners
410: where partner_type=2 and
411: partner_name = l_cust_name and
412: sr_instance_id = l_sr_instance_id;
413: