APPS.OTA_LP_NOTIFY_SS dependencies on OTA_LP_SECTIONS_TL

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