156: /* Begin of 1 */
157: for v_org_id in (select lv.sr_level_pk
158: from msd_level_values lv,
159: (select organization_lvl_pk opk
160: from msd_dp_scenario_entries
161: where demand_plan_id = p_demand_plan_id
162: and scenario_id = p_scenario_id
163: and revision = p_revision
164: group by organization_lvl_pk) sce
424: 'sce.time_lvl_val_to ' || ' ';
425:
426: -- from
427: l_from := l_from ||
428: ' msd_dp_scenario_entries sce, ' ||
429: ' msd_item_list_price lp ';
430:
431: -- where
432: l_where := l_where ||