[Home] [Help]
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
779: and lpm.activity_version_id = evt.activity_version_id
780: and tdb.event_id = evt.event_id
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
802: and lpm.activity_version_id = evt.activity_version_id
803: and tdb.event_id = evt.event_id
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
824: and lpm.activity_version_id = evt.activity_version_id
825: and tdb.event_id = evt.event_id
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
847: and lpm.activity_version_id = evt.activity_version_id
848: and tdb.event_id = evt.event_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
989: AND bst.booking_status_type_id = tdb.booking_status_type_id