APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_PLANS

Line 233: FROM msc_plans

229:
230: CURSOR plan_buckets IS
231: SELECT DECODE(g_designator, -1, trunc(sysdate), trunc(curr_start_date)) - 1,
232: DECODE(g_designator, -1, trunc(sysdate+365), trunc(curr_cutoff_date))
233: FROM msc_plans
234: WHERE plan_id = g_designator;
235:
236: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
237: SELECT cal.calendar_date

Line 613: from msc_plans

609: CURSOR get_plan_type(p_plan_id NUMBER) IS
610: select plan_type,
611: decode(enforce_sup_cap_constraints,1,1,0),
612: decode(daily_material_constraints,1, 1, 0) --ascp_supplier_constraints
613: from msc_plans
614: where plan_id = p_plan_id;
615:
616: l_constraints number:=0;
617: l_enforce_sup_cap_constraints number:=0;