[Home] [Help]
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
773: where lpc.learning_path_id = lpe.learning_path_id
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
796: where lpc.learning_path_id = lpe.learning_path_id
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
818: where lpc.learning_path_id = lpe.learning_path_id
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
841: where lpc.learning_path_id = lpe.learning_path_id
879: return 'Y';
880: END is_path_successful;
881:
882: Procedure Start_comp_proc_success_attnd(p_person_id in number ,
883: p_event_id in ota_Events.event_id%type)
884: is
885:
886: cursor get_lp_enroll is
887: select lp_enrollment_id, lpe.learning_path_id
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
893: and evt.event_id = p_event_id