The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select title
from ota_events_tl
where event_id = p_event_id
and language = userenv('LANG') ;
Select name
from hr_all_organization_units org
where ORG.ORGANIZATION_ID = center_id;
Select meaning
from fnd_lookups
where lookup_type='YES_NO' and lookup_code= p_code;
select replace(name,fnd_global.local_chr(10),fnd_global.local_chr(46))
into cp_venue
from ota_suppliable_resources_tl sr,
ota_resource_bookings rb
where rb.event_id = cf_venueformula.event_id
and rb.primary_venue_flag = 'Y'
and sr.supplied_resource_id = rb.supplied_resource_id
and sr.language = userenv('LANG') ;
select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'),calendar_aware)
into cp_course_end_date
from dual;
select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'),calendar_aware)
into cp_course_start_date
from dual;
Select meaning
into l_meaning
from fnd_lookups
where lookup_type='YES_NO' and lookup_code= p_code;