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_SECTIONS

Line 152: l_section_name OTA_LP_SECTIONS_TL.NAME%TYPE;

148: AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;--Bug 13826398
149:
150: l_lp_details csr_get_lp_details%ROWTYPE;
151: l_lpm_details csr_get_lpm_details%ROWTYPE;
152: l_section_name OTA_LP_SECTIONS_TL.NAME%TYPE;
153:
154: CURSOR csr_get_section_name IS
155: SELECT lpst.name
156: FROM ota_lp_sections_tl lpst,

Line 156: FROM ota_lp_sections_tl lpst,

152: l_section_name OTA_LP_SECTIONS_TL.NAME%TYPE;
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

Line 615: ota_lp_sections lpc

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
617: AND lpc.learning_path_id = lps.learning_path_id
618: AND lpc.learning_path_section_id = lpm.learning_path_section_id
619: AND lpme.learning_path_member_id = lpm.learning_path_member_id