APPS.OTA_TRNG_PLAN_UTIL_SS dependencies on OTA_EVENTS

Line 104: ota_events evt,

100:
101: CURSOR enroll_status IS
102: SELECT DECODE(bst.type,'C','Z',bst.type) status
103: FROM ota_training_plan_members tpm,
104: ota_events evt,
105: ota_delegate_bookings tdb,
106: ota_booking_status_types bst,
107: ota_training_plans tps
108: WHERE tpm.activity_version_id=evt.activity_version_id

Line 301: FROM ota_events e,

297: RETURN boolean
298: IS
299: CURSOR chk_enr IS
300: SELECT NULL
301: FROM ota_events e,
302: ota_activity_versions a,
303: ota_delegate_bookings b,
304: ota_booking_status_types s,
305: ota_training_plan_members tpm

Line 366: FROM ota_events evt,

362:
363:
364: CURSOR enroll_status_dates IS
365: SELECT DECODE(bst.type,'C','Z',bst.type) status
366: FROM ota_events evt,
367: ota_delegate_bookings tdb,
368: ota_booking_status_types bst
369: WHERE evt.event_id = tdb.event_id
370: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 393: FROM ota_events evt,

389: ORDER BY status;
390:
391: CURSOR enroll_status_without_dates IS
392: SELECT DECODE(bst.type,'C','Z',bst.type) status
393: FROM ota_events evt,
394: ota_delegate_bookings tdb,
395: ota_booking_status_types bst
396: WHERE evt.event_id = tdb.event_id
397: AND bst.booking_status_type_id = tdb.booking_status_type_id