APPS.OTA_TEA_BUS dependencies on OTA_DELEGATE_BOOKINGS

Line 19: from ota_delegate_bookings tdb

15: return boolean is
16: ---------------
17: cursor csr_tdb is
18: select 1
19: from ota_delegate_bookings tdb
20: where tdb.event_id = p_event_id
21: and tdb.customer_id = p_customer_id;
22: --
23: l_tdb_exist boolean;

Line 481: from ota_delegate_bookings tdb

477: l_proc varchar2(30) := 'check_enrollments';
478: --
479: cursor get_external_enrollments is
480: select null
481: from ota_delegate_bookings tdb
482: where tdb.event_id = p_event_id
483: and exists
484: (select null
485: from ota_event_associations tea

Line 492: from ota_delegate_bookings tdb

488: ,p_customer_id,tea.customer_id) = tdb.customer_id);
489: --
490: cursor get_internal_enrollments is
491: select asg.organization_id,asg.job_id,asg.position_id
492: from ota_delegate_bookings tdb
493: , per_assignments_f asg
494: , ota_events evt
495: where evt.event_id = p_event_id
496: and evt.event_id = tdb.event_id

Line 695: from ota_delegate_bookings a

691: --
692: Cursor delegate_count
693: IS
694: select sum(a.number_of_places)
695: from ota_delegate_bookings a
696: , ota_booking_status_types b
697: where a.booking_status_type_id = b.booking_status_type_id
698: and a.customer_id = p_customer
699: and a.event_id = p_event