APPS.MSD_DEM_SOP dependencies on MSC_PLAN_ORGANIZATIONS

Line 1636: SELECT organization_id FROM msc_plan_organizations

1632: series_id IN (105, 107, 115, 116, 117, 118);
1633:
1634: CURSOR c_get_plan_orgs
1635: IS
1636: SELECT organization_id FROM msc_plan_organizations
1637: WHERE plan_id = p_plan_id;
1638:
1639: errbuf VARCHAR2(200) := NULL;
1640: retcode VARCHAR2(100) := NULL;

Line 1768: SELECT organization_id FROM msc_plan_organizations

1764: series_id IN (115, 116);
1765:
1766: CURSOR c_get_plan_orgs
1767: IS
1768: SELECT organization_id FROM msc_plan_organizations
1769: WHERE plan_id = p_plan_id;
1770:
1771:
1772: errbuf VARCHAR2(200) := NULL;

Line 1894: SELECT organization_id FROM msc_plan_organizations

1890: series_id IN (119, 120);
1891:
1892: CURSOR c_get_plan_orgs
1893: IS
1894: SELECT organization_id FROM msc_plan_organizations
1895: WHERE plan_id = p_plan_id;
1896:
1897: x_dm_time_level NUMBER := NULL;
1898: x_dm_time_bucket VARCHAR2(30) := NULL;