APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_PLANS

Line 300: FROM msc_plans

296: -- -------------------------------------------------
297: CURSOR plan_buckets IS
298: SELECT DECODE(arg_plan_id, -1, sysdate, trunc(curr_start_date)),
299: DECODE(arg_plan_id, -1, sysdate+365, trunc(curr_cutoff_date))
300: FROM msc_plans
301: WHERE plan_id = arg_plan_id;
302:
303: -- -------------------------------------------------
304: -- This cursor selects the dates for the buckets.

Line 1974: FROM msc_plans

1970: -- =============================================================================
1971: BEGIN
1972:
1973: SELECT plan_type into l_plan_type
1974: FROM msc_plans
1975: WHERE plan_id = arg_plan_id;
1976:
1977: g_error_stmt := 'Debug - populate_horizontal_plan - 10';
1978: OPEN plan_buckets;

Line 3227: FROM msc_plans

3223: decode(period_material_constraints,1, 1, 0) +
3224: decode(period_resource_constraints,1, 1, 0),
3225: decode(enforce_sup_cap_constraints,1,1,0),
3226: decode(daily_material_constraints,1, 1, 0) --ascp_supplier_constraints
3227: FROM msc_plans
3228: WHERE plan_id = p_plan_id;
3229:
3230: l_plan_start_date date;
3231: l_plan_type number;