DBA Data[Home] [Help]

APPS.MSC_X_HZ_UPDATE dependencies on MSC_CAL_WEEK_START_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