APPS.MSC_PLAN_RELEASE dependencies on MSC_TRADING_PARTNER_SITES

Line 890: msc_trading_partner_sites mtps

886:
887: CURSOR loc_C IS
888: select mtps.sr_tp_site_id
889: from msc_trading_partners mtp,
890: msc_trading_partner_sites mtps
891: where mtp.sr_tp_id = p_org_id
892: AND mtp.sr_instance_id = p_inst_id
893: AND mtp.partner_type =3
894: AND mtps.partner_id = mtp.partner_id;

Line 1122: FROM msc_trading_partner_sites s

1118: l_partner_id NUMBER;
1119:
1120: CURSOR C2 IS
1121: SELECT s.sr_tp_site_id, s.location
1122: FROM msc_trading_partner_sites s
1123: where s.partner_id = l_partner_id;
1124:
1125: l_loc_id NUMBER;
1126: l_loc_code varchar2(80);