APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_PLANS

Line 75: FROM msc_plans

71: -- -------------------------------------------------
72: CURSOR plan_buckets IS
73: SELECT DECODE(arg_plan_id, -1, sysdate, trunc(curr_start_date)),
74: DECODE(arg_plan_id, -1, sysdate+365, trunc(curr_cutoff_date))
75: FROM msc_plans
76: WHERE plan_id = arg_plan_id;
77:
78: CURSOR get_plan_type IS
79: Select plan_type

Line 80: FROM msc_plans

76: WHERE plan_id = arg_plan_id;
77:
78: CURSOR get_plan_type IS
79: Select plan_type
80: FROM msc_plans
81: WHERE plan_id = arg_plan_id;
82:
83: -- -------------------------------------------------
84: -- This cursor selects the dates for the buckets.