APPS.OTA_INITIALIZATION_WF dependencies on OTA_LEARNING_OBJECTS

Line 1497: from ota_learning_objects olb, ota_attempts oa

1493:
1494: cursor get_test_info is
1495: select olb.name,oa.raw_score,oa.time
1496: -- ,oa.event_id
1497: from ota_learning_objects olb, ota_attempts oa
1498: where olb.learning_object_id = oa.learning_object_id
1499: -- and oa.attempt_id = op.attempt_id
1500: and oa.attempt_id =p_attempt_id;
1501:

Line 1507: l_title ota_learning_objects.name%type;

1503: l_item_key wf_items.item_key%type;
1504: l_item_type wf_items.item_type%type := 'OTWF';
1505: l_process wf_activities.name%type := 'OTA_ASSESSMENT_NTF_JSP_PRC';
1506:
1507: l_title ota_learning_objects.name%type;
1508: l_score varchar2(100);
1509:
1510: l_time ota_events.course_start_time%type;
1511: l_format_time varchar2(50);