APPS.MSC_RP_RELEASE_PUB dependencies on MSC_TRADING_PARTNER_SITES

Line 780: msc_trading_partner_sites mtps

776:
777: CURSOR loc_C IS
778: select mtps.sr_tp_site_id
779: from msc_trading_partners mtp,
780: msc_trading_partner_sites mtps
781: where mtp.sr_tp_id = p_org_id
782: AND mtp.sr_instance_id = p_inst_id
783: AND mtp.partner_type =3
784: AND mtps.partner_id = mtp.partner_id;

Line 1001: FROM msc_trading_partner_sites s

997: l_partner_id NUMBER;
998:
999: CURSOR C2 IS
1000: SELECT s.sr_tp_site_id, s.location
1001: FROM msc_trading_partner_sites s
1002: where s.partner_id = l_partner_id;
1003:
1004: l_loc_id NUMBER;
1005: l_loc_code varchar2(80);