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_LP_MEMBER_ENROLLMENTS

Line 111: FROM ota_lp_member_enrollments lpme,

107: lpme.completion_target_date completion_target,
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,

Line 157: ota_lp_member_enrollments lpme,

153:
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')

Line 612: ota_lp_member_enrollments lpme,

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
616: WHERE lpe.learning_path_id = lps.learning_path_id

Line 627: FROM ota_lp_member_enrollments

623: AND trunc(sysdate) + lpm.notify_days_before_target = trunc(lpme.completion_target_date)
624: AND (lpc.completion_type_code = 'M'
625: OR (lpc.completion_type_code = 'S'
626: AND lpc.no_of_mandatory_courses < (SELECT count(lp_member_enrollment_id)
627: FROM ota_lp_member_enrollments
628: WHERE learning_path_section_id = lpc.learning_path_section_id
629: AND lp_enrollment_id = lpe.lp_enrollment_id
630: AND member_status_code = 'COMPLETED')))
631: