The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT duration, duration_type, frequency
FROM iby_irf_pmt_frequency
WHERE ( payeeid = ci_payeeid )
OR ( payeeid is null and ci_payeeid is null);
SELECT count(1)
FROM iby_trxn_summaries_all tx
WHERE ((ci_ccNumber = instrNumber) OR (ci_ccNumHash = instrnum_hash))
AND reqdate >= ci_fromDate
AND reqType = 'ORAPMTREQ'
AND (status IN (0,11,100,111))
AND payeeid = ci_payeeid;
SELECT count(1)
FROM iby_trxn_summaries_all tx
WHERE (ci_instrid = payerInstrid)
AND reqdate >= ci_fromDate
AND reqType = 'ORAPMTREQ'
AND (status IN (0,11,100,111))
AND payeeid = ci_payeeid;
select count(1) into l_count
from iby_irf_pmt_frequency
where payeeid = i_payeeid;
** select the number of purchases after "fromDate" value
*/
l_no_of_purchases := 0;