DBA Data[Home] [Help]

APPS.OTA_OTARPSIS_XMLP_PKG dependencies on OTA_SUPPLIABLE_RESOURCES_TL

Line 116: from ota_suppliable_resources_tl sr,

112: begin
113:
114: select replace(name,fnd_global.local_chr(10),fnd_global.local_chr(46))
115: into cp_venue
116: from ota_suppliable_resources_tl sr,
117: ota_resource_bookings rb
118: where rb.event_id = cf_venueformula.event_id
119: and rb.primary_venue_flag = 'Y'
120: and sr.supplied_resource_id = rb.supplied_resource_id