APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_TRADING_PARTNER_SITES

Line 251: msc_trading_partner_sites mtps

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
255: AND mtps.partner_id = mtp.partner_id;