The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT khr.khr_id prog_khr_id
FROM okl_k_headers khr
WHERE khr.id = cp_chr_id;
SELECT pr.id cpl_id
FROM okc_k_party_roles_b pr
WHERE pr.rle_code = 'OKL_VENDOR'
AND pr.cle_id IS NULL
AND pr.chr_id = cp_chr_id
AND pr.dnz_chr_id = cp_chr_id;
SELECT SYS_CONTEXT ('USERENV','NLS_DATE_FORMAT')
FROM dual;
SELECT end_date
FROM okc_k_headers_b
WHERE id = cp_chr_id;