[Home] [Help]
258:
259: CURSOR csr_m_lpm IS
260: SELECT count(lpm.learning_path_member_id)
261: FROM ota_lp_sections lpc,
262: ota_learning_path_members lpm
263: WHERE lpc.learning_path_id = p_learning_path_id
264: and lpm.learning_path_section_id = lpc.learning_path_section_id
265: AND completion_type_code = 'M';
266:
687: WHERE learning_path_section_id = p_learning_path_section_id;
688:
689: CURSOR csr_m_lpm IS
690: SELECT count(learning_path_member_id)
691: FROM ota_learning_path_members lpm,
692: ota_lp_sections lpc
693: WHERE lpc.learning_path_section_id = p_learning_path_section_id
694: AND lpm.learning_path_section_id = lpc.learning_path_section_id
695: AND lpc.completion_type_code = 'M';
768: select
769: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
770: max(lpc.no_of_mandatory_courses) no_of_courses
771: from ota_lp_sections lpc
772: , ota_learning_path_members lpm
773: , ota_events evt
774: , ota_delegate_bookings tdb
775: , ota_lp_enrollments lpe
776: , ota_booking_status_types bst
791: select
792: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
793: sum(1) no_of_courses
794: from ota_lp_sections lpc
795: , ota_learning_path_members lpm
796: , ota_events evt
797: , ota_delegate_bookings tdb
798: , ota_lp_enrollments lpe
799: , ota_booking_status_types bst
813: select
814: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
815: max(lpc.no_of_mandatory_courses) no_of_courses
816: from ota_lp_sections lpc
817: , ota_learning_path_members lpm
818: , ota_events evt
819: , ota_delegate_bookings tdb
820: , ota_lp_enrollments lpe
821: , ota_booking_status_types bst
836: select
837: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
838: sum(1) no_of_courses
839: from ota_lp_sections lpc
840: , ota_learning_path_members lpm
841: , ota_events evt
842: , ota_delegate_bookings tdb
843: , ota_lp_enrollments lpe
844: , ota_booking_status_types bst
888: is
889:
890: cursor get_lp_enroll is
891: select lp_enrollment_id, lpe.learning_path_id
892: From ota_learning_path_members lpm
893: , ota_events evt
894: , ota_lp_enrollments lpe
895: where evt.activity_version_id = lpm.activity_version_id
896: and lpm.learning_path_id = lpe.learning_path_id
957: lpm.business_group_id,
958: lpm.learning_path_section_id,
959: lpme.lp_member_enrollment_id
960: FROM ota_lp_enrollments lpe,
961: ota_learning_path_members lpm,
962: ota_lp_member_enrollments lpme
963: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id
964: AND lpe.learning_path_id = lpm.learning_path_id
965: --AND lpe.path_status_code <> 'CANCELLED'
967: AND lpm.learning_path_member_id = lpme.learning_path_member_id ;
968:
969: CURSOR enrolled_class(p_person_id IN ota_learning_paths.person_id%TYPE,
970: p_contact_id IN ota_learning_paths.contact_id%TYPE,
971: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE) IS
972: SELECT oav.activity_version_id,
973: evt.event_id,
974: evt.course_start_date,
975: evt.course_start_time,
1036: CURSOR csr_lp_enrl_id_person IS
1037: SELECT lpe.lp_enrollment_id
1038: FROM ota_lp_enrollments lpe,
1039: ota_events oev,
1040: ota_learning_path_members lpm
1041: WHERE lpe.person_id = p_person_id
1042: AND oev.event_id = p_event_id
1043: AND NVL(lpe.is_history_flag, 'N') = 'N'
1044: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')
1049: CURSOR csr_lp_enrl_id_contact IS
1050: SELECT lpe.lp_enrollment_id
1051: FROM ota_lp_enrollments lpe,
1052: ota_events oev,
1053: ota_learning_path_members lpm
1054: WHERE lpe.contact_id = p_contact_id
1055: AND oev.event_id = p_event_id
1056: AND NVL(lpe.is_history_flag, 'N') = 'N'
1057: AND lpe.path_status_code NOT IN ('CANCELLED', 'REJECTED', 'AWAITING_APPROVAL')