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 1534: ota_resource_bookings r

1530: CURSOR primary_venue_cr
1531: IS
1532: SELECT s.location_id
1533: FROM ota_suppliable_resources s,
1534: ota_resource_bookings r
1535: WHERE r.supplied_resource_id = s.supplied_resource_id
1536: AND r.event_id = p_event_id
1537: AND primary_venue_flag = 'Y';
1538: