DBA Data[Home] [Help]

APPS.MSC_HP_UTIL dependencies on MSC_CAL_WEEK_START_DATES

Line 100: msc_cal_week_start_dates mw

96: max(decode(md.seq_num, null, null, md.calendar_date)) week_last_work_date
97: from
98: msc_plan_buckets b,
99: msc_calendar_dates md,
100: msc_cal_week_start_dates mw
101: where b.plan_id=p_plan_id
102: and b.curr_flag=1
103: and md.calendar_date between b.bkt_start_date and b.bkt_end_date
104: and md.calendar_code=l_calendar_code