APPS.OTA_TBD_API dependencies on OTA_EVENTS

Line 331: ota_events c

327: cursor c_check_date_change is
328: select nvl(count(a.booking_deal_id),0)
329: from ota_finance_lines a,
330: ota_delegate_bookings b,
331: ota_events c
332: where a.booking_deal_id = p_booking_deal_id
333: and a.booking_id = b.booking_id
334: and b.event_id = c.event_id
335: and p_start_date <= nvl(c.course_start_date,p_start_date)

Line 755: from OTA_EVENTS EVT

751: nvl (EVT.COURSE_START_DATE,hr_api.g_sot),
752: nvl (EVT.COURSE_END_DATE ,hr_api.g_eot),
753: maximum_attendees,
754: price_basis
755: from OTA_EVENTS EVT
756: where EVT.EVENT_ID = P_EVENT_ID;
757: --
758: begin
759: --