APPS.MSD_DEM_SOP dependencies on MSC_APPS_INSTANCES

Line 1912: from msc_apps_instances;

1908: c_dem_sched dem_sched;
1909:
1910: cursor get_instances is
1911: select instance_id
1912: from msc_apps_instances;
1913:
1914: l_master_org NUMBER := NULL;
1915: l_category_set_id NUMBER := NULL;
1916:

Line 3424: from msc_apps_instances mai

3420: from msc_trading_partners mtp,
3421: msc_tp_id_lid mtil
3422: where mtil.sr_tp_id = bsb.level3_sr_pk
3423: and mtil.sr_instance_id = (select instance_id
3424: from msc_apps_instances mai
3425: where mai.instance_code = substr(bsb.level2,1,instr(bsb.level2,':')-1)
3426: )
3427: and mtil.partner_type = 2
3428: and mtil.tp_id = mtp.partner_id