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 2332: from ota_delegate_bookings

2328: ,p_price_basis);
2329: --
2330: cursor get_enrollments is
2331: select null
2332: from ota_delegate_bookings
2333: where event_id = p_event_id;
2334: --
2335: cursor get_event_associations is
2336: select null

Line 2808: from ota_delegate_bookings

2804: -- cursor to check if delegate bookings exist for the event
2805: --
2806: Cursor c_delegate_bookings_details is
2807: select 'X'
2808: from ota_delegate_bookings
2809: where event_id = p_event_id;
2810: -- 6683076
2811: -- cursor to check if evaluation exists for the event
2812: --

Line 3068: ota_delegate_bookings tdb

3064: --
3065: cursor csr_st_finance_lines is
3066: select 1
3067: from ota_finance_lines tfl,
3068: ota_delegate_bookings tdb
3069: where tdb.event_id = p_event_id
3070: and tdb.booking_id = tfl.booking_id
3071: and tfl.transfer_status = 'ST'
3072: and tfl.cancelled_flag = 'N';