APPS.MSC_PHUB_UTIL dependencies on MSC_SCENARIO_PLANS
Line 162: from msc_scenario_plans sp, msc_scenarios s,
158:
159: FUNCTION get_default_plan_id(p_scenario_id number, p_plan_type number, p_plan_run_name varchar2) return number is
160: cursor c_default_plan_id(p_scenario_id varchar2) is
161: select distinct p.plan_id 162: from msc_scenario_plans sp, msc_scenarios s, 163: (select distinct plan_id, plan_type from msc_plans
164: union all
165: select distinct scenario_id, to_number(10)
166: from msd_dp_ascp_scenarios_v