APPS.MSC_REPPERIODS_PUB dependencies on MSC_CALENDAR_DATES

Line 51: FROM msc_calendar_dates

47:
48: -- Get the last date in this calendar
49: SELECT MAX(calendar_date)
50: INTO var_max_date
51: FROM msc_calendar_dates
52: WHERE calendar_code = var_calendar_code
53: AND exception_set_id = var_exception_set_id
54: AND seq_num IS NOT NULL;
55:

Line 117: FROM msc_calendar_dates

113: -- Get the current workday
114:
115: SELECT next_date
116: INTO var_curr_workday
117: FROM msc_calendar_dates
118: WHERE calendar_code = var_calendar_code
119: AND exception_set_id = var_exception_set_id
120: AND calendar_date = var_curr_date
121: AND sr_instance_id = arg_instance_id;

Line 214: FROM msc_calendar_dates

210: -- workday. We'll delete those that are not updated in the next step.
211: UPDATE msc_repetitive_periods s
212: SET period_start_date =
213: (SELECT next_date
214: FROM msc_calendar_dates
215: WHERE calendar_code = var_calendar_code
216: AND exception_set_id = var_exception_set_id
217: AND calendar_date = s.period_start_date)
218: WHERE EXISTS

Line 220: FROM msc_calendar_dates d

216: AND exception_set_id = var_exception_set_id
217: AND calendar_date = s.period_start_date)
218: WHERE EXISTS
219: (SELECT NULL
220: FROM msc_calendar_dates d
221: WHERE NOT EXISTS
222: (SELECT NULL
223: FROM msc_repetitive_periods
224: WHERE organization_id = s.organization_id

Line 239: FROM msc_calendar_dates d

235: WHERE organization_id = arg_org_id
236: AND sr_instance_id = arg_instance_id
237: AND EXISTS
238: (SELECT NULL
239: FROM msc_calendar_dates d
240: WHERE seq_num IS NULL
241: AND calendar_code = var_calendar_code
242: AND exception_set_id = var_exception_set_id
243: AND calendar_date = s.period_start_date);