APPS.OTA_TDB_BUS2 dependencies on OTA_DELEGATE_BOOKINGS

Line 113: from ota_delegate_bookings db,

109: ,evt.course_start_date evt_course_start_date
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

Line 351: l_global_bg ota_delegate_bookings.business_group_id%type :=

347: p_sponsor_assignment_id in number,
348: p_date_booking_placed in date) is
349: l_proc varchar2(72) := g_package||'check_org_business_group';
350: l_dummy varchar2(30);
351: l_global_bg ota_delegate_bookings.business_group_id%type :=
352: FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
353: --
354: --
355: cursor c_person (l_person_id number) is

Line 903: FROM OTA_DELEGATE_BOOKINGS

899:
900: CURSOR C_EVENT
901: IS
902: SELECT OLD_EVENT_ID,DAEMON_TYPE
903: FROM OTA_DELEGATE_BOOKINGS
904: WHERE
905: BOOKING_ID = p_booking_id;
906:
907: l_proc varchar2(72) := g_package||'chk_event_changed';