DBA Data[Home] [Help]

APPS.MSC_SCN_UTILS dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 1871: from msd_dp_ascp_scenarios_v

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

Line 2709: msd_dp_ascp_scenarios_v mdas

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