APPS.OTA_COMPETENCE_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 721: from ota_activity_versions oav,ota_offerings off,ota_events oev

717: where learning_path_id = l_id;
718:
719: cursor get_course_off_setting(l_id number) is
720: select oav.competency_update_level,off.competency_update_level
721: from ota_activity_versions oav,ota_offerings off,ota_events oev
722: where oav.activity_version_id = off.activity_version_id
723: and off.offering_id = oev.parent_offering_id
724: and
725: oev.event_id = l_id;

Line 1449: l_course_name ota_activity_versions.version_name%type;

1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1446:
1447: l_event_name ota_events.title%type;
1448:
1449: l_course_name ota_activity_versions.version_name%type;
1450: l_process_display_name varchar2(240);
1451:
1452: l_loop_counter number(15) := 0;
1453: l_will_comp_update varchar2(50);

Line 1527: from ota_Events_vl oev ,ota_activity_versions_tl oav

1523: WHERE employee_id= l_supervisor_id;
1524:
1525: Cursor csr_name is
1526: select oev.title,oav.version_name
1527: from ota_Events_vl oev ,ota_activity_versions_tl oav
1528: --,ota_offerings off
1529: where
1530: --oev.parent_offering_id=off.offering_id and
1531: oev.activity_version_id= oav.activity_version_id