10420: IF (G_HIERARCHY_PROFILE = 1) THEN
10421:
10422: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10423: INTO x_priority, x_alloc_percent, x_level_id
10424: FROM msc_allocations ma
10425: WHERE ma.demand_class = p_demand_class
10426: AND ma.time_phase_id = l_time_phase
10427: AND ma.level_id = -1;
10428:
10429: ELSE
10430:
10431: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10432: INTO x_priority, x_alloc_percent, x_level_id
10433: FROM msc_allocations ma
10434: WHERE ma.demand_class = p_demand_class
10435: AND ma.time_phase_id = l_time_phase
10436: AND ma.level_id <> -1;
10437:
10490: IF G_HIERARCHY_PROFILE = 1 THEN
10491:
10492: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10493: INTO x_priority, x_alloc_percent, x_level_id
10494: FROM msc_allocations ma
10495: WHERE ma.demand_class = p_demand_class
10496: AND ma.time_phase_id = l_time_phase
10497: AND ma.level_id = -1;
10498:
10499: ELSE
10500:
10501: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10502: INTO x_priority, x_alloc_percent, x_level_id
10503: FROM msc_allocations ma
10504: WHERE ma.demand_class = p_demand_class
10505: AND ma.time_phase_id = l_time_phase
10506: AND ma.level_id <> -1;
10507: