DBA Data[Home] [Help]

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