DBA Data[Home] [Help]

APPS.OTA_OTARPATT_XMLP_PKG dependencies on OTA_SUPPLIABLE_RESOURCES_TL

Line 140: from ota_suppliable_resources_tl sr,

136: begin
137:
138: select replace(name,fnd_global.local_chr(10),fnd_global.local_chr(46))
139: into cp_venue
140: from ota_suppliable_resources_tl sr,
141: ota_resource_bookings rb
142: where rb.event_id = cf_venueformula.event_id
143: and rb.primary_venue_flag = 'Y'
144: and sr.supplied_resource_id = rb.supplied_resource_id