APPS.MSC_PHUB_PKG dependencies on MSC_INSTANCE_ORGS

Line 1844: from msc_instance_orgs

1840: where plan_id=-1;
1841:
1842: select organization_id
1843: into l_pi.organization_id
1844: from msc_instance_orgs
1845: where rownum=1 and sr_instance_id=p_sr_instance_id;
1846:
1847: l_pi.plan_id := -1;
1848: l_pi.plan_type := -1;

Line 1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;

1895: );
1896: end loop;
1897: commit;
1898:
1899: --populate msc_plan_organizations one row for each org from msc_instance_orgs where sr_instance_id = p_sr_instance_id;
1900: msc_phub_util.log('Populating msc_plan_organizations');
1901: delete from msc_plan_organizations
1902: where plan_id=-1;
1903: commit;

Line 1934: from msc_instance_orgs mio,

1930: fnd_global.user_id,
1931: sysdate,
1932: fnd_global.user_id,
1933: fnd_global.login_id
1934: from msc_instance_orgs mio,
1935: msc_trading_partners mtp
1936: where mio.sr_instance_id = p_sr_instance_id
1937: and mio.sr_instance_id = mtp.sr_instance_id
1938: and mio.organization_id = mtp.sr_tp_id