APPS.OTA_LP_NOTIFY_SS dependencies on OTA_LP_SECTIONS

Line 150: l_section_name OTA_LP_SECTIONS_TL.NAME%TYPE;

146: WHERE person_id = p_person_id;
147:
148: l_lp_details csr_get_lp_details%ROWTYPE;
149: l_lpm_details csr_get_lpm_details%ROWTYPE;
150: l_section_name OTA_LP_SECTIONS_TL.NAME%TYPE;
151:
152: CURSOR csr_get_section_name IS
153: SELECT lpst.name
154: FROM ota_lp_sections_tl lpst,

Line 154: FROM ota_lp_sections_tl lpst,

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

Line 594: ota_lp_sections lpc

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
596: AND lpc.learning_path_id = lps.learning_path_id
597: AND lpc.learning_path_section_id = lpm.learning_path_section_id
598: AND lpme.learning_path_member_id = lpm.learning_path_member_id