64: --dbms_output.put_line('Cal Code' || calendarCode);
65: --dbms_output.put_line('newArrivalDate' || newarrivalDate);
66:
67: select n.calendar_date into d4
68: from msc_calendar_dates original,
69: msc_calendar_dates n
70: where original.calendar_code = calendarCode
71: and original.exception_set_id = -1
72: and original.sr_instance_id = srInstanceId
65: --dbms_output.put_line('newArrivalDate' || newarrivalDate);
66:
67: select n.calendar_date into d4
68: from msc_calendar_dates original,
69: msc_calendar_dates n
70: where original.calendar_code = calendarCode
71: and original.exception_set_id = -1
72: and original.sr_instance_id = srInstanceId
73: and original.calendar_date = newarrivalDate