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.PER_ZA_WSP_ARCHIVE_PKG dependencies on OTA_EVENTS

Line 2990: from ota_events oe

2986: --
2987: -- Courses
2988: cursor csr_wsp_courses(p_person_id number) is
2989: select oav.activity_version_id, oav.version_name
2990: from ota_events oe
2991: ,ota_activity_versions oav
2992: ,ota_delegate_bookings odb
2993: ,ota_booking_status_types obst
2994: where odb.delegate_person_id = p_person_id

Line 3627: from ota_events oe

3623:
3624: -- Courses
3625: cursor csr_atr_courses(p_person_id number) is
3626: select oav.activity_version_id, oav.version_name, odb.date_status_changed ,obst.name "status"
3627: from ota_events oe
3628: ,ota_activity_versions oav
3629: ,ota_delegate_bookings odb
3630: ,ota_booking_status_types obst
3631: where odb.delegate_person_id = p_person_id