The following lines contain the word 'select', 'insert', 'update' or 'delete':
select version_name
from ota_activity_versions_tl
where activity_version_id = P_ACTIVITY_ID
and language = userenv('LANG');
select title
from ota_events_tl
where event_id = P_EVENT_ID
and language = userenv('LANG') ;
select es.meaning
from hr_lookups es
WHERE es.lookup_type='OTA_EVAL_REPORT_TYPE'
AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
AND es.enabled_flag ='Y'
AND es.lookup_code = P_ANSWER_TYPE ;
select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
into C_FROM_DATE
from dual;
select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
into C_TO_DATE
from dual;