APPS.OTA_EVT_BUS dependencies on OTA_DELEGATE_BOOKINGS

Line 335: OTA_DELEGATE_BOOKINGS TDB

331: select BST.TYPE
332: FROM OTA_BOOKING_STATUS_TYPES BST ,
333: PER_ALL_PEOPLE_F DEL ,
334: OTA_EVENTS EVT ,
335: OTA_DELEGATE_BOOKINGS TDB
336: where tdb.business_group_id = p_business_group_id
337: and evt.event_id = p_event_id
338: AND TDB.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID
339: AND TDB.EVENT_ID = EVT.EVENT_ID

Line 797: from ota_delegate_bookings

793: l_exists varchar2(1);
794: --
795: cursor get_enrollments is
796: select null
797: from ota_delegate_bookings
798: where event_id = p_event_id;
799: --
800: cursor get_tea is
801: select null

Line 1309: from ota_delegate_bookings

1305: l_dummy varchar2(30);
1306: --
1307: cursor check_dates is
1308: select 'X'
1309: from ota_delegate_bookings
1310: where event_id = p_event_id
1311: -- Modified for bug#5107347
1312: and ota_timezone_util.convert_date(trunc(date_booking_placed)
1313: , to_char(date_booking_placed, 'HH24:MI')

Line 2351: from ota_delegate_bookings

2347: ,p_price_basis);
2348: --
2349: cursor get_enrollments is
2350: select null
2351: from ota_delegate_bookings
2352: where event_id = p_event_id;
2353: --
2354: cursor get_event_associations is
2355: select null

Line 2828: from ota_delegate_bookings

2824: -- cursor to check if delegate bookings exist for the event
2825: --
2826: Cursor c_delegate_bookings_details is
2827: select 'X'
2828: from ota_delegate_bookings
2829: where event_id = p_event_id;
2830: -- 6683076
2831: -- cursor to check if evaluation exists for the event
2832: --

Line 3088: ota_delegate_bookings tdb

3084: --
3085: cursor csr_st_finance_lines is
3086: select 1
3087: from ota_finance_lines tfl,
3088: ota_delegate_bookings tdb
3089: where tdb.event_id = p_event_id
3090: and tdb.booking_id = tfl.booking_id
3091: and tfl.transfer_status = 'ST'
3092: and tfl.cancelled_flag = 'N';