APPS.MSC_PHUB_PKG dependencies on MSC_PLANS

Line 30: from msc_plans

26: decode(plan_id, -1, sysdate+365, trunc(curr_cutoff_date)) curr_cutoff_date,
27: curr_plan_type,
28: nvl(plan_completion_date, sysdate),
29: nvl(display_kpi,1)
30: from msc_plans
31: where plan_id = g_plan_id;
32:
33: --plan archival
34: cursor c_prior_plan_run is