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 110: FROM ota_lp_member_enrollments lpme,

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

Line 155: ota_lp_member_enrollments lpme,

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

Line 591: ota_lp_member_enrollments lpme,

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

Line 606: FROM ota_lp_member_enrollments

602: AND trunc(sysdate) + lpm.notify_days_before_target = trunc(lpme.completion_target_date)
603: AND (lpc.completion_type_code = 'M'
604: OR (lpc.completion_type_code = 'S'
605: AND lpc.no_of_mandatory_courses < (SELECT count(lp_member_enrollment_id)
606: FROM ota_lp_member_enrollments
607: WHERE learning_path_section_id = lpc.learning_path_section_id
608: AND lp_enrollment_id = lpe.lp_enrollment_id
609: AND member_status_code = 'COMPLETED')))
610: