DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_CALENDAR_DATES

Line 2027: FROM msc_calendar_dates

2023:
2024:
2025: CURSOR seqnum_cursor(p_date DATE) IS
2026: SELECT next_seq_num
2027: FROM msc_calendar_dates
2028: WHERE calendar_code = calendar_code
2029: AND exception_set_id = exc_set_id
2030: AND sr_instance_id = p_inst_id
2031: AND calendar_date = p_date;

Line 2035: FROM msc_calendar_dates

2031: AND calendar_date = p_date;
2032:
2033: CURSOR prior_seqnum_cursor(p_date DATE) IS
2034: SELECT prior_seq_num
2035: FROM msc_calendar_dates
2036: WHERE calendar_code = calendar_code
2037: AND exception_set_id = exc_set_id
2038: AND sr_instance_id = p_inst_id
2039: AND calendar_date = p_date;