APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_TRADING_PARTNERS

Line 24: from msc_trading_partners

20: p_impl_as number;
21:
22: cursor c_modeled_supplier is
23: select modeled_supplier_id
24: from msc_trading_partners
25: where sr_tp_id = p_dest_org_id
26: and sr_instance_id= p_dest_inst_id
27: and partner_type= 3;
28:

Line 250: from msc_trading_partners mtp,

246: AND mp.current_employee_flag = 1;
247:
248: CURSOR loc_C IS
249: select mtps.sr_tp_site_id
250: from msc_trading_partners mtp,
251: msc_trading_partner_sites mtps
252: where mtp.sr_tp_id = p_org_id
253: AND mtp.sr_instance_id = p_inst_id
254: AND mtp.partner_type =3