APPS.MSC_WS_OTM_BPEL dependencies on MSC_CALENDAR_DATES

Line 68: from msc_calendar_dates original,

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

Line 69: msc_calendar_dates n

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