APPS.MSC_PHUB_UTIL dependencies on MSC_PHUB_DATES_MV

Line 1027: from msc_phub_dates_mv

1023: nvl(lag(calendar_date) over(order by calendar_date)+1, p_plan_start_date-1),
1024: calendar_date,
1025: fnd_global.user_id, sysdate,
1026: sysdate, fnd_global.user_id, fnd_global.login_id
1027: from msc_phub_dates_mv
1028: where calendar_date between p_plan_start_date and p_plan_cutoff_date
1029: and calendar_date in (mfg_week_end_date, fis_period_end_date, month_end_date, p_plan_cutoff_date);
1030:
1031: log('msc_phub_util.get_reporting_dates, l_qid_last_date='||l_qid_last_date||', count='||sql%rowcount);