APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 772: , ota_booking_status_types bst

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
775: and lpm.activity_version_id = evt.activity_version_id
776: and tdb.event_id = evt.event_id

Line 795: , ota_booking_status_types bst

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
798: and lpm.activity_version_id = evt.activity_version_id
799: and tdb.event_id = evt.event_id

Line 817: , ota_booking_status_types bst

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
820: and lpm.activity_version_id = evt.activity_version_id
821: and tdb.event_id = evt.event_id

Line 840: , ota_booking_status_types bst

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
843: and lpm.activity_version_id = evt.activity_version_id
844: and tdb.event_id = evt.event_id