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_CPR_UTILITY dependencies on OTA_OFFERINGS

Line 219: ota_offerings OFR,

215: OCU.online_flag,
216: OFR.learning_object_id
217: FROM
218: ota_activity_versions OAV,
219: ota_offerings OFR,
220: ota_events OEV,
221: ota_category_usages OCU
222: WHERE
223: OFR.activity_version_id = OAV.activity_version_id

Line 231: CURSOR c_learning_object_status(p_lo_id in ota_offerings.learning_object_id%TYPE) is

227: And (OEV.event_type = 'SCHEDULED' or OEV.event_type = 'SELFPACED')
228: And OEV.event_status <> 'A'
229: And OAV.activity_version_id = p_act_ver_id;
230:
231: CURSOR c_learning_object_status(p_lo_id in ota_offerings.learning_object_id%TYPE) is
232: SELECT lesson_status
233: FROM ota_performances
234: WHERE
235: user_id = p_user_id

Line 437: FROM ota_events evt, ota_offerings ofr

433: ) IS
434:
435: Cursor c_get_act_ver_id is
436: SELECT ofr.activity_version_id
437: FROM ota_events evt, ota_offerings ofr
438: WHERE evt.event_id = p_event_id
439: and evt.parent_offering_id = ofr.offering_id;
440:
441: Cursor get_ext_lrn_party_id is