APPS.OTA_ILEARNING dependencies on OTA_DELEGATE_BOOKINGS

Line 667: ota_delegate_bookings

663: cursor cur_check_enroll_exist is
664: select
665: count(*)
666: from
667: ota_delegate_bookings
668: where
669: event_id = l_event_id;
670:
671: cursor cur_waitlist_size is

Line 673: from ota_delegate_bookings

669: event_id = l_event_id;
670:
671: cursor cur_waitlist_size is
672: select count(*)
673: from ota_delegate_bookings
674: where booking_status_type_id in (SELECT booking_status_type_id
675: FROM ota_booking_status_types
676: WHERE type = 'W')
677: and event_id = l_event_id;

Line 682: from ota_delegate_bookings

678:
679:
680: cursor cur_get_total_placed is
681: select count(*)
682: from ota_delegate_bookings
683: where booking_status_type_id in (SELECT booking_status_type_id
684: FROM ota_booking_status_types
685: WHERE type in ('A','P','E'))
686: and event_id = l_event_id;