APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 774: , ota_delegate_bookings tdb

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
777: where lpc.learning_path_id = lpe.learning_path_id
778: and lpm.learning_path_section_id = lpc.learning_path_section_id

Line 797: , ota_delegate_bookings tdb

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
800: where lpc.learning_path_id = lpe.learning_path_id
801: and lpm.learning_path_section_id = lpc.learning_path_section_id

Line 819: , ota_delegate_bookings tdb

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
822: where lpc.learning_path_id = lpe.learning_path_id
823: and lpm.learning_path_section_id = lpc.learning_path_section_id

Line 842: , ota_delegate_bookings tdb

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
845: where lpc.learning_path_id = lpe.learning_path_id
846: and lpm.learning_path_section_id = lpc.learning_path_section_id

Line 984: ota_delegate_bookings tdb,

980: tdb.delegate_person_id,
981: tdb.delegate_contact_id
982: FROM ota_activity_versions oav,
983: ota_events evt,
984: ota_delegate_bookings tdb,
985: ota_booking_status_types bst
986: WHERE oav.activity_version_id = p_activity_version_id
987: AND oav.activity_version_id = evt.activity_version_id
988: AND evt.event_id = tdb.event_id

Line 997: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%type;

993:
994: l_path_status_code VARCHAR2(30);
995: l_enroll_type VARCHAR2(30);
996: l_date_status_changed DATE;
997: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%type;
998:
999: begin
1000: if(ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id) = 'Y') then
1001: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'COMPLETED', 810);