APPS.MSD_ASCP_FLOW dependencies on MSD_DP_ASCP_SCENARIOS_V

Line 32: FROM msd_dp_ascp_scenarios_v

28: WHERE compile_designator = l_default_plan_name;
29:
30: CURSOR c_scn_count (l_dp_plan_id IN NUMBER, l_default_scenario_id IN NUMBER) IS
31: SELECT count(*)
32: FROM msd_dp_ascp_scenarios_v
33: WHERE demand_plan_id = l_dp_plan_id
34: AND scenario_id = l_default_scenario_id;
35:
36: CURSOR c_org_id (l_plan_id IN NUMBER) IS

Line 55: FROM msd_dp_ascp_scenarios_v

51: SELECT count(*)
52: FROM msc_plan_schedules
53: WHERE plan_id = l_plan_id
54: AND input_schedule_id in ( SELECT scenario_id
55: FROM msd_dp_ascp_scenarios_v
56: WHERE demand_plan_id = l_dp_plan_id)
57: AND designator_type = 7;
58:
59: