APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSC_PLANS

Line 2028: msc_plans mp

2024: cursor c_ascp_stream(p_demand_plan_id number) is
2025: select mdp.parameter_id
2026: from msd_dp_parameters mdp,
2027: msd_cs_definitions mcd,
2028: msc_plans mp
2029: where mdp.demand_plan_id = p_demand_plan_id
2030: and mdp.parameter_type = mcd.name
2031: and nvl(mcd.MULTIPLE_STREAM_FLAG,'N') = 'Y'
2032: and mdp.parameter_name = mp.compile_designator;

Line 2041: msc_plans mp

2037: where demand_plan_id = p_demand_plan_id
2038: and parameter_id not in ( select mdp.parameter_id
2039: from msd_dp_parameters mdp,
2040: msd_cs_definitions mcd,
2041: msc_plans mp
2042: where mdp.demand_plan_id = p_demand_plan_id
2043: and mdp.parameter_type = mcd.name
2044: and nvl(mcd.MULTIPLE_STREAM_FLAG,'N') = 'Y'
2045: and mdp.parameter_name = mp.compile_designator);

Line 2281: l_new_stmt := 'SELECT COUNT(*) FROM ' || l_source || ' src, msc_plans desig WHERE ';

2277:
2278: /* Select, FROM portions of Dynamic Statement */
2279: l_stmt := 'SELECT COUNT(*) FROM ' || l_source || ' src WHERE ';
2280: If c_input_rec.ascp_stream_flag = 'Y' then
2281: l_new_stmt := 'SELECT COUNT(*) FROM ' || l_source || ' src, msc_plans desig WHERE ';
2282: end if;
2283:
2284: /* For Streams other than Input Scenario use Generic Where clause */
2285: IF (c_input_rec.parameter_type_id NOT IN ('MSD_INPUT_SCENARIO')) THEN