The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT VALUE
FROM OKL_SGN_TRANSLATIONS
WHERE JTOT_OBJECT1_CODE = 'FA_METHODS'
AND object1_id1 = p_id;
SELECT VALUE
FROM OKL_SGN_TRANSLATIONS
WHERE JTOT_OBJECT1_CODE = 'FA_CONVENTION_TYPES'
AND object1_id1 = p_id;
SELECT
sfe.deal_type,sil.sil_type
FROM okl_stream_interfaces_v sfe,
okl_sif_lines_v sil
WHERE transaction_number = cp_transaction_no
AND sil.sif_id = sfe.id;
SELECT
AMOUNT
FROM
OKL_SIF_FEES SFEB,
OKL_STREAM_INTERFACES SIFB
WHERE
SFEB.SIF_ID = SIFB.ID AND
SFEB.SFE_TYPE = 'SFR' AND
SFEB.FEE_INDEX_NUMBER = cp_fee_index AND
SIFB.transaction_number = cp_transaction_no;
SELECT FEES.BALANCE_TYPE_CODE
FROM OKL_SIF_FEES_V FEES,
OKL_STREAM_INTERFACES SIF
WHERE SIF.TRANSACTION_NUMBER = p_trx_number
AND SIF.ID = FEES.SIF_ID
AND FEES.BALANCE_TYPE_CODE IS NOT NULL;
SELECT fee_purpose_code
FROM OKL_K_LINES
WHERE ID = p_fee_line_id;
SELECT KHR_ID
FROM OKL_STREAM_INTERFACES
WHERE TRANSACTION_NUMBER = p_trx_number;
SELECT count(crl.id)
FROM okc_rule_groups_b crg,
okc_rules_b crl,
okl_strm_type_v sty
WHERE crl.rgp_id = crg.id
AND crg.rgd_code = 'LALEVL'
AND crl.rule_information_category = 'LASLH'
AND crg.dnz_chr_id = chrId
AND crl.object1_id1 = sty.id
AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
ORDER BY crl.rule_information1;