The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
FROM JAI_OM_LC_HDRS
WHERE lc_number = pr_new.lc_number;
SELECT LC_BALANCE_AMOUNT
FROM JAI_OM_LC_HDRS
WHERE LC_NUMBER = pr_new.LC_NUMBER;
UPDATE JAI_OM_LC_HDRS
SET lc_balance_amount = ROUND(NVL(lc_balance_amount,0),2) - ROUND(NVL(lv_amount_applied,0),2)
WHERE lc_number = pr_new.lc_number;