DBA Data[Home] [Help]

APPS.MSC_SCN_UTILS dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 1875: from msd_dp_ascp_scenarios_v

1871: from msc_plans
1872: where plan_type = nvl(p_plan_type,plan_type) and plan_id = p_plan_id
1873: union
1874: select distinct scenario_name as plan_name
1875: from msd_dp_ascp_scenarios_v
1876: where scenario_id=p_plan_id and p_plan_type=10;
1877:
1878: cursor c_plan_name_arch is
1879: select plan_run_name

Line 2712: msd_dp_ascp_scenarios_v mdas

2708:
2709: cursor c_dem_run_date is
2710: select last_update_date
2711: from msd_dp_scenario_revisions mdr,
2712: msd_dp_ascp_scenarios_v mdas
2713: where mdr.scenario_id=mdas.scenario_id and
2714: mdr.revision = mdas.last_revision;
2715:
2716: l_run_date date;