DBA Data[Home] [Help]

APPS.MSC_UPDATE_RESOURCE dependencies on MSC_TRADING_PARTNERS

Line 157: FROM msc_trading_partners mtp,

153: l_work_day number;
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