APPS.MSC_UPDATE_RESOURCE dependencies on MSC_CALENDAR_DATES

Line 158: msc_calendar_dates dates

154:
155: CURSOR NWD is
156: SELECT nvl(dates.seq_num, -1)
157: FROM msc_trading_partners mtp,
158: msc_calendar_dates dates
159: WHERE dates.calendar_date = trunc(g_shift_date)
160: AND dates.calendar_code = mtp.calendar_code
161: AND dates.exception_set_id = mtp.calendar_exception_set_id
162: AND dates.sr_instance_id = mtp.sr_instance_id