APPS.MSC_X_HZ_UPDATE dependencies on MSC_CALENDAR_DATES

Line 439: FROM msc_calendar_dates cal, msc_cal_week_start_dates wsd

435:
436: if v_bucket_type(arg_pos) = WEEK_BUCKET then
437: SELECT cal.prior_date
438: INTO v_date
439: FROM msc_calendar_dates cal, msc_cal_week_start_dates wsd
440: WHERE cal.calendar_code = wsd.calendar_code
441: AND wsd.calendar_code = 'CP-Mon-70'
442: AND wsd.exception_set_id = -1
443: AND wsd.sr_instance_id = 0

Line 454: FROM msc_calendar_dates cal, msc_period_start_dates psd

450: elsif v_bucket_type(arg_pos) = MONTH_BUCKET then
451:
452: SELECT cal.next_date
453: INTO v_date
454: FROM msc_calendar_dates cal, msc_period_start_dates psd
455: WHERE psd.calendar_code = 'CP-Mon-70' AND
456: psd.exception_set_id = -1 AND
457: psd.sr_instance_id = 0 AND
458: psd.next_date > TRUNC(TO_DATE(v_start, 'DD/MM/YYYY HH24:MI:SS')) AND