APPS.MSC_AATP_PVT dependencies on MSC_ALLOCATIONS

Line 10193: FROM msc_allocations ma

10189: IF (G_HIERARCHY_PROFILE = 1) THEN
10190:
10191: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10192: INTO x_priority, x_alloc_percent, x_level_id
10193: FROM msc_allocations ma
10194: WHERE ma.demand_class = p_demand_class
10195: AND ma.time_phase_id = l_time_phase
10196: AND ma.level_id = -1;
10197:

Line 10202: FROM msc_allocations ma

10198: ELSE
10199:
10200: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10201: INTO x_priority, x_alloc_percent, x_level_id
10202: FROM msc_allocations ma
10203: WHERE ma.demand_class = p_demand_class
10204: AND ma.time_phase_id = l_time_phase
10205: AND ma.level_id <> -1;
10206:

Line 10263: FROM msc_allocations ma

10259: IF G_HIERARCHY_PROFILE = 1 THEN
10260:
10261: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10262: INTO x_priority, x_alloc_percent, x_level_id
10263: FROM msc_allocations ma
10264: WHERE ma.demand_class = p_demand_class
10265: AND ma.time_phase_id = l_time_phase
10266: AND ma.level_id = -1;
10267:

Line 10272: FROM msc_allocations ma

10268: ELSE
10269:
10270: SELECT ma.priority, ma.allocation_percent/100, ma.level_id
10271: INTO x_priority, x_alloc_percent, x_level_id
10272: FROM msc_allocations ma
10273: WHERE ma.demand_class = p_demand_class
10274: AND ma.time_phase_id = l_time_phase
10275: AND ma.level_id <> -1;
10276: