APPS.OTA_TDB_BUS2 dependencies on OTA_EVENTS

Line 115: ota_events ev,

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)))
119: and db.booking_status_type_id = bst.booking_status_type_id

Line 116: ota_events evt

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)))
119: and db.booking_status_type_id = bst.booking_status_type_id
120: and bst.type <> g_cancelled_booking

Line 168: FROM OTA_EVENTS evt

164: /* For Bug 2241280 */
165: CURSOR csr_event_type
166: IS
167: SELECT evt.event_type
168: FROM OTA_EVENTS evt
169: WHERE evt.event_id= p_event_id;
170: --
171: l_proc varchar2(72) := g_package||'other_bookings_clash';
172: l_result boolean;

Line 625: l_event_type ota_events.price_basis%type;

621: p_enrollment_type in varchar2,
622: p_booking_id in number) is
623: --
624: l_proc varchar2(72) := g_package||'oheck_enrollment_type';
625: l_event_type ota_events.price_basis%type;
626: cursor c1 is
627: select price_basis
628: from ota_events
629: where event_id = p_event_id;

Line 628: from ota_events

624: l_proc varchar2(72) := g_package||'oheck_enrollment_type';
625: l_event_type ota_events.price_basis%type;
626: cursor c1 is
627: select price_basis
628: from ota_events
629: where event_id = p_event_id;
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);

Line 694: from ota_events

690: l_sponsor_end_date date;
691: --
692: cursor c_event is
693: select course_start_date
694: from ota_events
695: where event_id = p_event_id;
696: --
697: /* Modified p_date_booking_placed to trunc(p_date_booking_placed)for bug 6402358*/
698:

Line 941: l_event_end_date ota_events.course_end_date%TYPE;

937: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;
938: l_commitment_number ra_customer_trx_all.trx_number%TYPE;
939: l_commitment_end_date ra_customer_trx_all.end_date_commitment%TYPE;
940: l_commitment_start_date ra_customer_trx_all.start_date_commitment%TYPE;
941: l_event_end_date ota_events.course_end_date%TYPE;
942: --
943: CURSOR c_event
944: IS SELECT course_end_date
945: FROM ota_events

Line 945: FROM ota_events

941: l_event_end_date ota_events.course_end_date%TYPE;
942: --
943: CURSOR c_event
944: IS SELECT course_end_date
945: FROM ota_events
946: WHERE event_id = p_event_id;
947: l_proc VARCHAR2(72) := g_package||'check_commitment_date';
948: BEGIN
949: hr_utility.set_location('Entering:'||l_proc,5);