APPS.MSD_FCST_PUB dependencies on MSD_DP_SCENARIOS

Line 111: select output_period_type into v_time_lvl_id from msd_dp_scenarios

107: errbuf := '';
108:
109: -- Before we begin, we find time level - days, weeks, or periods
110:
111: select output_period_type into v_time_lvl_id from msd_dp_scenarios
112: where demand_plan_id = p_demand_plan_id and scenario_id = p_scenario_id;
113:
114: if (v_time_lvl_id= 9) then v_bucket_type := 1;
115: elsif (v_time_lvl_id = 1) then v_bucket_type := 2;