eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_INITIALIZATION_WF dependencies on OTA_LEARNING_PATHS

Line 1223: from ota_learning_paths lp , ota_learning_paths_tl lpt, ota_lp_enrollments lpe

1219:
1220: cursor get_lp_info
1221: is
1222: select lpt.name, lpe.person_id, lp.start_date_active
1223: from ota_learning_paths lp , ota_learning_paths_tl lpt, ota_lp_enrollments lpe
1224: where lpt.learning_path_id = lp.learning_path_id
1225: and lpt.Language= USERENV('LANG')
1226: and lp.Learning_path_id = lpe.Learning_path_id
1227: and lpe.lp_enrollment_id = p_lp_enrollment_id;

Line 1230: l_LP_name ota_learning_paths_tl.name%type;

1226: and lp.Learning_path_id = lpe.Learning_path_id
1227: and lpe.lp_enrollment_id = p_lp_enrollment_id;
1228:
1229: l_person_id per_people_f.person_id%type;
1230: l_LP_name ota_learning_paths_tl.name%type;
1231: l_start_date ota_learning_paths.start_date_active%type;
1232: l_process wf_activities.name%type := 'OTA_LP_JSP_PRC';
1233: l_item_key wf_items.item_key%type;
1234:

Line 1231: l_start_date ota_learning_paths.start_date_active%type;

1227: and lpe.lp_enrollment_id = p_lp_enrollment_id;
1228:
1229: l_person_id per_people_f.person_id%type;
1230: l_LP_name ota_learning_paths_tl.name%type;
1231: l_start_date ota_learning_paths.start_date_active%type;
1232: l_process wf_activities.name%type := 'OTA_LP_JSP_PRC';
1233: l_item_key wf_items.item_key%type;
1234:
1235: