APPS.HRI_OLTP_DISC_TRAINING dependencies on OTA_SUPPLIABLE_RESOURCES

Line 271: ota_suppliable_resources sr

267: ,sr.cost_unit
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