DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on OTA_BOOKING_STATUS_TYPES

Line 114: ota_booking_status_types bst,

110: ,decode(evt.course_start_date, NULL, NULL, nvl(evt.course_start_time,'00:00')) evt_course_start_time
111: ,evt.course_end_date evt_course_end_date
112: ,decode(evt.course_end_date, NULL, NULL, nvl(evt.course_end_time,'23:59')) evt_course_end_time
113: from ota_delegate_bookings db,
114: ota_booking_status_types bst,
115: ota_events ev,
116: ota_events evt
117: where ( (p_delegate_contact_id IS NULL AND db.delegate_person_id = p_delegate_person_id
118: OR (p_delegate_person_id IS NULL AND db.delegate_contact_id = p_delegate_contact_id)))