APPS.HRI_OLTP_DISC_TRAINING dependencies on OTA_RESOURCE_BOOKINGS

Line 272: ,ota_resource_bookings rb

268: ,nvl(sr.cost,0) * nvl(rb.quantity,0) *
269: nvl(trunc(rb.required_date_to - rb.required_date_FROM + 1),0) cost
270: FROM
271: ota_suppliable_resources sr
272: ,ota_resource_bookings rb
273: WHERE rb.supplied_resource_id = sr.supplied_resource_id
274: AND rb.event_id = p_csr_event_id
275: AND rb.status = 'C'; -- Confirmed bookings only
276: