APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_EVENTS_TL

Line 421: l_class_name ota_events_tl.title%type;

417: --Bug 5386501
418: Cursor csr_class_data is
419: Select title from ota_events_vl
420: where event_id = p_event_id;
421: l_class_name ota_events_tl.title%type;
422: l_incoming_status_type varchar2(30);
423:
424: --Bug 6683076
425: Cursor c_eval_info is

Line 1620: FROM ota_events_tl oet, ota_events oe

1616:
1617:
1618: CURSOR event_csr(p_old_event_id ota_events.event_id%TYPE) IS
1619: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
1620: FROM ota_events_tl oet, ota_events oe
1621: WHERE oet.event_id = oe.event_id
1622: AND oe.event_id = p_old_event_id
1623: AND oet.language = userenv('LANG');
1624:

Line 2933: FROM ota_events_tl oet, ota_events oe

2929: l_waitlist_size NUMBER := 0;
2930:
2931: CURSOR event_csr(p_event_id ota_events.event_id%TYPE) IS
2932: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
2933: FROM ota_events_tl oet, ota_events oe
2934: WHERE oet.event_id = oe.event_id
2935: AND oe.event_id = p_event_id
2936: AND oet.language = userenv('LANG');
2937: