APPS.MSC_GET_NAME dependencies on MSC_CALENDAR_DATES

Line 2429: FROM msc_calendar_dates

2425:
2426:
2427: CURSOR seqnum_cursor(p_date DATE) IS
2428: SELECT next_seq_num
2429: FROM msc_calendar_dates
2430: WHERE calendar_code = calendar_code
2431: AND exception_set_id = exc_set_id
2432: AND sr_instance_id = p_inst_id
2433: AND calendar_date = p_date;

Line 2437: FROM msc_calendar_dates

2433: AND calendar_date = p_date;
2434:
2435: CURSOR prior_seqnum_cursor(p_date DATE) IS
2436: SELECT prior_seq_num
2437: FROM msc_calendar_dates
2438: WHERE calendar_code = calendar_code
2439: AND exception_set_id = exc_set_id
2440: AND sr_instance_id = p_inst_id
2441: AND calendar_date = p_date;

Line 5429: FROM msc_calendar_dates cal

5425: cursor get_sys_seq_num(p_exc_set_id number,
5426: p_cal_code in varchar2,
5427: p_date date) is
5428: SELECT cal.next_seq_num
5429: FROM msc_calendar_dates cal
5430: WHERE cal.exception_set_id = p_exc_set_id
5431: AND cal.calendar_code = p_cal_code
5432: AND cal.calendar_date = TRUNC(p_date)
5433: AND cal.sr_instance_id = p_inst_id;

Line 5440: FROM msc_calendar_dates cal

5436: p_cal_code in varchar2,
5437: p_seq_num in number,
5438: p_cutoff_days in number) is
5439: SELECT cal.calendar_date
5440: FROM msc_calendar_dates cal
5441: WHERE cal.exception_set_id = p_exc_set_id
5442: AND cal.calendar_code = p_cal_code
5443: AND cal.seq_num = p_seq_num + p_cutoff_days
5444: AND cal.sr_instance_id = p_inst_id;