APPS.OTA_CPR_UTILITY dependencies on OTA_PERFORMANCES

Line 233: FROM ota_performances

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
236: AND user_type = p_user_type
237: AND learning_object_id = p_lo_id;

Line 241: l_lo_status ota_performances.lesson_status%type;

237: AND learning_object_id = p_lo_id;
238:
239: l_enrollment_status varchar2(1);
240: l_completed_status varchar2(1);
241: l_lo_status ota_performances.lesson_status%type;
242:
243: Begin
244: l_completed_status := 'N';
245: For a_event_rec In c_get_classes() Loop