The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DECODE(e.parent_type,'CAMP',s.source_code,e.source_code) event_source_code
FROM
AMS_EVENT_OFFERS_ALL_B e,
ams_campaign_schedules_b s
WHERE
e.event_offer_id = s.related_event_id (+)
AND s.related_event_from(+) = 'EONE'
AND e.EVENT_OFFER_ID = p_event_id;
/* SELECT 'Y' -- fix for bug 15876260
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'
AND COLUMN_NAME = 'SURVEY_TYPE'
AND OWNER = p_table_owner; */
SELECT 'Y'
FROM user_synonyms syn, dba_tab_columns col
WHERE syn.synonym_name = 'IES_SVY_SURVEYS_ALL'
AND col.owner = syn.table_owner
AND col.table_name = syn.table_name
--AND col.owner = p_table_owner
AND col.column_name = 'SURVEY_TYPE';
select svy.survey_type
from ies_svy_surveys_all svy,
IES_SVY_CYCLES_ALL cyc,
IES_SVY_DEPLYMENTS_ALL dep
where dep.survey_deployment_id = p_deployment_id
and dep.survey_cycle_id = cyc.survey_cycle_id
and cyc.survey_id = svy.survey_id;
select source_code_id from ams_source_codes
where arc_source_code_for = 'CSCH'
and source_code_for_id = p_schedule_id
and active_flag='Y';
select action_param_id,action_param_code
from ams_clik_thru_act_params_b
where action_id=p_action_id;