The following lines contain the word 'select', 'insert', 'update' or 'delete':
select GRP.GROUP_NAME into l_servergroup_name
from IEO_SVR_GROUPS GRP, IEO_SVR_SERVERS svr
where grp.server_group_id=svr.member_svr_group_id
and svr.server_id=p_MCMID;
SELECT a.agent_id
FROM cct_agent_rt_stats a
WHERE mcm_id = p_mcm_id;
Select def.application_id,decode(def.application_id,511,'TELESERVICE',
521,'TELESALES','OTHER')
into p_app_id,p_app_name
from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
where act.maction_def_id=def.maction_def_id
and type.media_type_uuid=p_mediaTypeUUID
and type.media_type_id=act.media_type_id
and upper(act.classification)=upper(p_classification);
Select act.application_id,decode(act.application_id,511,'TELESERVICE',
521,'TELESALES','OTHER')
into p_app_id,p_app_name
from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
where act.maction_def_id=def.maction_def_id
and type.media_type_uuid=p_mediaTypeUUID
and type.media_type_id=act.media_type_id
and upper(act.classification)=upper('unClassified');
Select act.application_id,decode(act.application_id,511,'TELESERVICE',
521,'TELESALES','OTHER')
into p_app_id,p_app_name
from ieu_uwq_media_actions act,ieu_uwq_media_types_b type,ieu_uwq_maction_defs_b def
where act.maction_def_id=def.maction_def_id
and type.media_type_uuid=p_mediaTypeUUID
and type.media_type_id=act.media_type_id
and act.classification is null;