APPS.MSD_FCST_PUB dependencies on MSD_LEVELS

Line 466: from msd_levels

462: -- now, if p_level_id and p_value_id are not null, we need to add yet another filter
463: if (p_level_id is not null) and (p_value_id is not null) then
464:
465: select dimension_code into dim
466: from msd_levels
467: where level_id = p_level_id;
468:
469: -- zia 4/12/01 handle case where this dimension is not in the plan
470: begin

Line 477: from msd_levels mlv,

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,
478: msd_dp_dimensions mdd
479: where mdd.demand_plan_id = p_demand_plan_id
480: and mdd.dimension_code = mlv.dimension_code
481: and mlv.level_id = mdsol.level_id