APPS.MSC_ATP_PVT dependencies on MSC_CALENDAR_DATES

Line 19461: FROM msc_calendar_dates

19457: msc_sch_wb.atp_debug('Get_Seq_Num: p_instance_id: ' || p_instance_id);
19458: END IF;
19459: SELECT seq_num
19460: INTO l_seq_num
19461: FROM msc_calendar_dates
19462: WHERE calendar_code = p_calendar_code
19463: AND seq_num is not null --This date will always be there only case is if ITF is non working day.
19464: AND calendar_date = trunc(p_calendar_date)
19465: AND sr_instance_id = p_instance_id

Line 19501: FROM msc_calendar_dates

19497: END IF;
19498:
19499: SELECT calendar_date
19500: INTO l_date
19501: FROM msc_calendar_dates
19502: WHERE calendar_code = p_calendar_code
19503: AND seq_num = p_seq_num --Seq should always be there if calendar is build till ITF.
19504: AND sr_instance_id = p_instance_id
19505: AND exception_set_id = -1;