DBA Data[Home] [Help]

APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 770: , ota_delegate_bookings tdb

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

Line 793: , ota_delegate_bookings tdb

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

Line 815: , ota_delegate_bookings tdb

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

Line 838: , ota_delegate_bookings tdb

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