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 111: ota_learning_path_members lpm,

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

Line 156: ota_learning_path_members lpm

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

Line 590: FROM ota_learning_path_members lpm,

586: ,lpe.person_id
587: ,lpe.creator_person_id
588: ,lps.path_source_code
589: ,lpm.notify_days_before_target
590: FROM ota_learning_path_members lpm,
591: ota_lp_member_enrollments lpme,
592: ota_learning_paths lps,
593: ota_lp_enrollments lpe,
594: ota_lp_sections lpc