APPS.MSC_CALENDAR dependencies on MSC_CAL_WEEK_START_DATES

Line 62: FROM msc_cal_week_start_dates

58: SELECT min(week_start_date), max(week_start_date), min(seq_num),
59: max(seq_num)
60: INTO min_week_date, max_week_date, min_week_seq_num,
61: max_week_seq_num
62: FROM msc_cal_week_start_dates
63: WHERE calendar_code = arg_calendar_code
64: AND exception_set_id = arg_exception_set_id
65: AND sr_instance_id = arg_instance_id ;
66:

Line 207: FROM msc_cal_week_start_dates cal

203:
204: BEGIN
205: SELECT week_start_date
206: INTO var_return_date
207: FROM msc_cal_week_start_dates cal
208: WHERE cal.exception_set_id = var_exception_set_id
209: AND cal.calendar_code = var_calendar_code
210: AND cal.seq_num = arg_seq_num + l_arg_offset
211: AND cal.sr_instance_id = arg_instance_id;

Line 270: FROM msc_cal_week_start_dates cal

266: var_return_date := min_week_date;
267: ELSE
268: SELECT MIN(cal.week_start_date)
269: INTO var_return_date
270: FROM msc_cal_week_start_dates cal
271: WHERE cal.exception_set_id = var_exception_set_id
272: AND cal.calendar_code = var_calendar_code
273: AND cal.week_start_date >= TRUNC(arg_date)
274: AND cal.sr_instance_id = arg_instance_id ;

Line 337: FROM msc_cal_week_start_dates cal

333: var_return_date := min_week_date;
334: ELSE
335: SELECT MAX(cal.week_start_date)
336: INTO var_return_date
337: FROM msc_cal_week_start_dates cal
338: WHERE cal.exception_set_id = var_exception_set_id
339: AND cal.calendar_code = var_calendar_code
340: AND cal.week_start_date <= TRUNC(arg_date)
341: AND cal.sr_instance_id = arg_instance_id;

Line 396: FROM msc_cal_week_start_dates cal

392: var_return_number := min_seq_num;
393: ELSE
394: SELECT MIN(cal.seq_num)
395: INTO var_return_number
396: FROM msc_cal_week_start_dates cal
397: WHERE cal.exception_set_id = var_exception_set_id
398: AND cal.calendar_code = var_calendar_code
399: AND cal.week_start_date >= TRUNC(arg_date)
400: AND cal.sr_instance_id = arg_instance_id ;

Line 442: FROM msc_cal_week_start_dates cal

438: var_return_number := min_week_seq_num;
439: ELSE
440: SELECT MAX(cal.seq_num)
441: INTO var_return_number
442: FROM msc_cal_week_start_dates cal
443: WHERE cal.exception_set_id = var_exception_set_id
444: AND cal.calendar_code = var_calendar_code
445: AND cal.week_start_date <= TRUNC(arg_date)
446: AND cal.sr_instance_id = arg_instance_id ;

Line 675: FROM msc_cal_week_start_dates

671: SELECT min(week_start_date), max(week_start_date), min(seq_num),
672: max(seq_num)
673: INTO min_week_date, max_week_date, min_week_seq_num,
674: max_week_seq_num
675: FROM msc_cal_week_start_dates
676: WHERE calendar_code = arg_calendar_code
677: AND exception_set_id = arg_exception_set_id ;
678:
679: msc_calendar_cal_code := arg_calendar_code;

Line 743: FROM msc_cal_week_start_dates cal

739: var_return_date := min_week_date;
740: ELSE
741: SELECT MIN(cal.week_start_date)
742: INTO var_return_date
743: FROM msc_cal_week_start_dates cal
744: WHERE cal.exception_set_id = var_exception_set_id
745: AND cal.calendar_code = arg_calendar_code
746: AND cal.week_start_date >= TRUNC(arg_date) ;
747: END IF;

Line 810: FROM msc_cal_week_start_dates cal

806: var_return_date := min_week_date;
807: ELSE
808: SELECT MAX(cal.week_start_date)
809: INTO var_return_date
810: FROM msc_cal_week_start_dates cal
811: WHERE cal.exception_set_id = var_exception_set_id
812: AND cal.calendar_code = arg_calendar_code
813: AND cal.week_start_date <= TRUNC(arg_date)
814: AND cal.sr_instance_id = arg_instance_id;

Line 874: FROM msc_cal_week_start_dates cal

870: var_return_number := min_week_seq_num;
871: ELSE
872: SELECT MAX(cal.seq_num)
873: INTO var_return_number
874: FROM msc_cal_week_start_dates cal
875: WHERE cal.exception_set_id = var_exception_set_id
876: AND cal.calendar_code = arg_calendar_code
877: AND cal.week_start_date <= TRUNC(arg_date) ;
878: END IF;