APPS.OTA_COMPETENCE_SS dependencies on OTA_LEARNING_PATHS

Line 716: from ota_learning_paths

712: where certification_id = l_id;
713:
714: cursor get_LP_setting(l_id number) is
715: select competency_update_level
716: from ota_learning_paths
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

Line 1536: select name from ota_learning_paths_TL

1532: and oev.event_id= p_eventid
1533: and Language= USERENV('LANG');
1534:
1535: cursor LP_name (csr_lp_id varchar2) is
1536: select name from ota_learning_paths_TL
1537: where learning_path_id =csr_lp_id
1538: and Language= USERENV('LANG');
1539:
1540: cursor chk_person_business_grp