APPS.OTA_UTILITY dependencies on OTA_RESOURCE_BOOKINGS

Line 115: from ota_resource_bookings

111: l_return_value Varchar2(100);
112:
113: cursor getcount
114: is select count(resource_booking_id)
115: from ota_resource_bookings
116: where event_id = peventid;
117: --and status ='C';
118:
119: begin

Line 1598: ota_resource_bookings r

1594: CURSOR primary_venue_cr
1595: IS
1596: SELECT s.location_id
1597: FROM ota_suppliable_resources s,
1598: ota_resource_bookings r
1599: WHERE r.supplied_resource_id = s.supplied_resource_id
1600: AND r.event_id = p_event_id
1601: AND primary_venue_flag = 'Y';
1602: