The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT * FROM WF_ROLES
WHERE NAME =p_role;
SELECT *
FROM ben_ext_rslt
WHERE ext_rslt_id= p_result_id
AND request_id = p_request_id;
SELECT DISTINCT (bed.name)
FROM ben_ext_dfn bed
WHERE bed.ext_dfn_id=cp_ext_dfn_id;
SELECT count(rslt.ext_rslt_id) rec_cnt
FROM ben_ext_rcd_in_file rin
,ben_ext_dfn dfn
,ben_ext_rslt_dtl rslt
WHERE dfn.ext_dfn_id = cp_dfn_id
AND rin.ext_file_id = dfn.ext_file_id
AND rin.hide_flag = 'N'
AND rin.ext_rcd_id = rslt.EXT_RCD_ID
and rslt.ext_rslt_id =cp_rslt_id;
SELECT ghr_nfc_notif_seq_s.nextval
INTO l_get_seq
FROM dual;
SELECT COUNT(*)
FROM wf_user_roles wur
WHERE wur.role_name =cp_role;