[Home] [Help]
APPS.OTA_CPR_BUS dependencies on OTA_EVENTS
Line 413: from OTA_EVENTS oev
409: ) is
410: --
411: cursor get_valid_classes is
412: select 'Y'
413: from OTA_EVENTS oev
414: where oev.ACTIVITY_VERSION_ID = p_prerequisite_course_id
415: and (oev.EVENT_TYPE = 'SCHEDULED' or oev.EVENT_TYPE = 'SELFPACED')
416: and oev.EVENT_STATUS <> 'A'
417: and nvl(trunc(oev.course_end_date), trunc(sysdate)) >= trunc(sysdate);