eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRNG_PLAN_UTIL_SS dependencies on OTA_DELEGATE_BOOKINGS

Line 105: ota_delegate_bookings tdb,

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
109: AND evt.event_id = tdb.event_id

Line 303: ota_delegate_bookings b,

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
306: WHERE e.event_id = b.event_id
307: AND tpm.activity_version_id = a.activity_version_id

Line 367: ota_delegate_bookings tdb,

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
371: AND (

Line 394: ota_delegate_bookings tdb,

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
398: AND evt.activity_version_id = p_activity_version_id