APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_LEARNING_PATH_MEMBERS

Line 258: ota_learning_path_members lpm

254:
255: CURSOR csr_m_lpm IS
256: SELECT count(lpm.learning_path_member_id)
257: FROM ota_lp_sections lpc,
258: ota_learning_path_members lpm
259: WHERE lpc.learning_path_id = p_learning_path_id
260: and lpm.learning_path_section_id = lpc.learning_path_section_id
261: AND completion_type_code = 'M';
262:

Line 687: FROM ota_learning_path_members lpm,

683: WHERE learning_path_section_id = p_learning_path_section_id;
684:
685: CURSOR csr_m_lpm IS
686: SELECT count(learning_path_member_id)
687: FROM ota_learning_path_members lpm,
688: ota_lp_sections lpc
689: WHERE lpc.learning_path_section_id = p_learning_path_section_id
690: AND lpm.learning_path_section_id = lpc.learning_path_section_id
691: AND lpc.completion_type_code = 'M';

Line 768: , ota_learning_path_members lpm

764: select
765: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
766: max(lpc.no_of_mandatory_courses) no_of_courses
767: from ota_lp_sections lpc
768: , ota_learning_path_members lpm
769: , ota_events evt
770: , ota_delegate_bookings tdb
771: , ota_lp_enrollments lpe
772: , ota_booking_status_types bst

Line 791: , ota_learning_path_members lpm

787: select
788: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
789: sum(1) no_of_courses
790: from ota_lp_sections lpc
791: , ota_learning_path_members lpm
792: , ota_events evt
793: , ota_delegate_bookings tdb
794: , ota_lp_enrollments lpe
795: , ota_booking_status_types bst

Line 813: , ota_learning_path_members lpm

809: select
810: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
811: max(lpc.no_of_mandatory_courses) no_of_courses
812: from ota_lp_sections lpc
813: , ota_learning_path_members lpm
814: , ota_events evt
815: , ota_delegate_bookings tdb
816: , ota_lp_enrollments lpe
817: , ota_booking_status_types bst

Line 836: , ota_learning_path_members lpm

832: select
833: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
834: sum(1) no_of_courses
835: from ota_lp_sections lpc
836: , ota_learning_path_members lpm
837: , ota_events evt
838: , ota_delegate_bookings tdb
839: , ota_lp_enrollments lpe
840: , ota_booking_status_types bst

Line 888: From ota_learning_path_members lpm

884: is
885:
886: cursor get_lp_enroll is
887: select lp_enrollment_id, lpe.learning_path_id
888: From ota_learning_path_members lpm
889: , ota_events evt
890: , ota_lp_enrollments lpe
891: where evt.activity_version_id = lpm.activity_version_id
892: and lpm.learning_path_id = lpe.learning_path_id