APPS.OTA_INITIALIZATION_WF dependencies on OTA_LEARNING_OBJECTS

Line 1499: from ota_learning_objects olb, ota_attempts oa

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

Line 1509: l_title ota_learning_objects.name%type;

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