APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_PLANS

Line 271: FROM msc_plans

267: -- -------------------------------------------------
268: CURSOR plan_buckets IS
269: SELECT DECODE(arg_plan_id, -1, sysdate, trunc(curr_start_date)),
270: DECODE(arg_plan_id, -1, sysdate+365, trunc(curr_cutoff_date))
271: FROM msc_plans
272: WHERE plan_id = arg_plan_id;
273:
274: -- -------------------------------------------------
275: -- This cursor selects the dates for the buckets.

Line 1794: FROM msc_plans

1790: -- =============================================================================
1791: BEGIN
1792:
1793: SELECT plan_type into l_plan_type
1794: FROM msc_plans
1795: WHERE plan_id = arg_plan_id;
1796:
1797: g_error_stmt := 'Debug - populate_horizontal_plan - 10';
1798: OPEN plan_buckets;

Line 3043: FROM msc_plans

3039: decode(period_material_constraints,1, 1, 0) +
3040: decode(period_resource_constraints,1, 1, 0),
3041: decode(enforce_sup_cap_constraints,1,1,0),
3042: decode(daily_material_constraints,1, 1, 0) --ascp_supplier_constraints
3043: FROM msc_plans
3044: WHERE plan_id = p_plan_id;
3045:
3046: l_plan_start_date date;
3047: l_plan_type number;