[Home] [Help]
469: -- zia 4/12/01 handle case where this dimension is not in the plan
470: begin
471:
472: SELECT mdsol.level_id into lvl
473: FROM msd_dp_scenario_output_levels mdsol
474: WHERE mdsol.demand_plan_id = p_demand_plan_id
475: and mdsol.scenario_id = p_scenario_id
476: and exists (select 1
477: from msd_levels mlv,