APPS.MSD_DEM_SOP dependencies on MSD_DEM_SERIES

Line 358: msd_dem_series

354: custom_view_name,
355: ps_view_name,
356: stg_series_col_name
357: FROM
358: msd_dem_series
359: WHERE
360: series_id = p_series_id;
361:
362:

Line 550: FROM msd_dem_series

546: CURSOR c_get_series_for_purge
547: IS
548: SELECT
549: series_id
550: FROM msd_dem_series
551: WHERE series_id IN (112, 113);
552:
553: Cursor c_plan_start_date is
554: select curr_start_date

Line 692: msd_dem_series

688: IS
689: SELECT
690: series_id
691: FROM
692: msd_dem_series
693: WHERE
694: series_id IN (101, 102, 103, 104, 105, 106, 107, 108, 109, 110);
695:
696: /*** LOCAL VARIABLES - BEGIN ***/

Line 1630: SELECT series_id FROM msd_dem_series

1626: ) IS
1627:
1628: CURSOR c_get_all_series
1629: IS
1630: SELECT series_id FROM msd_dem_series
1631: WHERE
1632: series_id IN (105, 107, 115, 116, 117, 118);
1633:
1634: CURSOR c_get_plan_orgs

Line 1762: SELECT series_id FROM msd_dem_series

1758: ) IS
1759:
1760: CURSOR c_get_all_series
1761: IS
1762: SELECT series_id FROM msd_dem_series
1763: WHERE
1764: series_id IN (115, 116);
1765:
1766: CURSOR c_get_plan_orgs

Line 1882: SELECT series_id FROM msd_dem_series

1878: p_jobs_timeout IN NUMBER default 86400)
1879: is
1880: CURSOR c_get_all_series
1881: IS
1882: SELECT series_id FROM msd_dem_series
1883: WHERE
1884: series_id IN (105, 107, 115, 116, 117, 118);
1885:
1886: CURSOR c_get_cost_series

Line 1888: SELECT series_id FROM msd_dem_series

1884: series_id IN (105, 107, 115, 116, 117, 118);
1885:
1886: CURSOR c_get_cost_series
1887: IS
1888: SELECT series_id FROM msd_dem_series
1889: WHERE
1890: series_id IN (119, 120);
1891:
1892: CURSOR c_get_plan_orgs