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
773: where lpc.learning_path_id = lpe.learning_path_id
774: and lpm.learning_path_section_id = lpc.learning_path_section_id
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
796: where lpc.learning_path_id = lpe.learning_path_id
797: and lpm.learning_path_section_id = lpc.learning_path_section_id
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
818: where lpc.learning_path_id = lpe.learning_path_id
819: and lpm.learning_path_section_id = lpc.learning_path_section_id
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
841: where lpc.learning_path_id = lpe.learning_path_id
842: and lpm.learning_path_section_id = lpc.learning_path_section_id