DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_TRADING_PARTNERS

Line 205: from msc_trading_partners mtp,

201: AND mp.current_employee_flag = 1;
202:
203: CURSOR loc_C IS
204: select mtps.sr_tp_site_id
205: from msc_trading_partners mtp,
206: msc_trading_partner_sites mtps
207: where mtp.sr_tp_id = p_org_id
208: AND mtp.sr_instance_id = p_inst_id
209: AND mtp.partner_type =3