APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_EVENTS_TL

Line 567: l_class_name ota_events_tl.title%type;

563: --Bug 5386501
564: Cursor csr_class_data is
565: Select title from ota_events_vl
566: where event_id = p_event_id;
567: l_class_name ota_events_tl.title%type;
568: l_incoming_status_type varchar2(30);
569:
570: --Bug 6683076
571: Cursor c_eval_info is

Line 1790: FROM ota_events_tl oet, ota_events oe

1786:
1787:
1788: CURSOR event_csr(p_old_event_id ota_events.event_id%TYPE) IS
1789: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
1790: FROM ota_events_tl oet, ota_events oe
1791: WHERE oet.event_id = oe.event_id
1792: AND oe.event_id = p_old_event_id
1793: AND oet.language = userenv('LANG');
1794:

Line 3166: FROM ota_events_tl oet, ota_events oe

3162: l_waitlist_size NUMBER := 0;
3163:
3164: CURSOR event_csr(p_event_id ota_events.event_id%TYPE) IS
3165: SELECT oet.title,oe.course_start_date,oe.course_start_time,oe.owner_id
3166: FROM ota_events_tl oet, ota_events oe
3167: WHERE oet.event_id = oe.event_id
3168: AND oe.event_id = p_event_id
3169: AND oet.language = userenv('LANG');
3170: