APPS.OTA_GENERIC_REPORT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

select distinct
      fl.currency_code
from
      ota_finance_lines fl,
      ota_events e,
      ota_delegate_bookings db
where  db.event_id = event
and db.booking_id  = fl.booking_id;

Line: 46

select distinct
      fl.currency_code
from
      ota_finance_lines fl,
      ota_events e,
      ota_resource_bookings rb,
      ota_activity_versions av
where rb.event_id = event
and rb.resource_booking_id  = fl.resource_booking_id;