APPS.OTA_TSR_BUS dependencies on OTA_RESOURCE_BOOKINGS

Line 436: from ota_resource_bookings

432: p_end_date in date) is
433: --
434: Cursor c_invalid_bookings is
435: select 'X'
436: from ota_resource_bookings
437: where supplied_resource_id = p_supplied_resource_id
438: and (required_date_from < p_start_date
439: or
440: nvl(required_date_to,hr_api.g_eot) > nvl(p_end_date,hr_api.g_eot));

Line 563: from ota_resource_bookings

559: Procedure del_check_bookings (p_supplied_resource_id in number) is
560: --
561: Cursor c_bookings is
562: select 'X'
563: from ota_resource_bookings
564: where supplied_resource_id = p_supplied_resource_id;
565: --
566: l_proc varchar2(72) := g_package||'check_bookings';
567: l_dummy varchar2(1);