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_LP_NOTIFY_SS dependencies on OTA_LEARNING_PATH_MEMBERS

Line 112: ota_learning_path_members lpm,

108: lpt.name path_name,
109: lpe.creator_person_id,
110: lpm.notify_days_before_target
111: FROM ota_lp_member_enrollments lpme,
112: ota_learning_path_members lpm,
113: ota_activity_versions_tl avt,
114: ota_lp_enrollments lpe,
115: ota_learning_paths lps,
116: ota_learning_paths_tl lpt

Line 158: ota_learning_path_members lpm

154: CURSOR csr_get_section_name IS
155: SELECT lpst.name
156: FROM ota_lp_sections_tl lpst,
157: ota_lp_member_enrollments lpme,
158: ota_learning_path_members lpm
159: WHERE lpme.learning_path_member_id = lpm.learning_path_member_id
160: AND lpst.learning_path_section_id = lpm.learning_path_section_id
161: AND lpst.language = USERENV('LANG')
162: AND lpme.lp_member_enrollment_id = p_lp_member_enrollment_id;

Line 611: FROM ota_learning_path_members lpm,

607: ,lpe.person_id
608: ,lpe.creator_person_id
609: ,lps.path_source_code
610: ,lpm.notify_days_before_target
611: FROM ota_learning_path_members lpm,
612: ota_lp_member_enrollments lpme,
613: ota_learning_paths lps,
614: ota_lp_enrollments lpe,
615: ota_lp_sections lpc