The following lines contain the word 'select', 'insert', 'update' or 'delete':
select parameter_id parm_id,
name parm_name,
datatype parm_datatype,
default_value
from ece_tran_parameters
where transaction_type = p_transaction_type
order by parameter_id, sequence_number;
select map_id, map_type from ece_mappings
where ece_mappings.transaction_type = p_transaction_type;
ec_utils.g_stack.DELETE;
select ece_output_runs_s.NEXTVAL INTO i_file_id
FROM DUAL;
m_parm_tmp_tbl.DELETE;