APPS.JAI_JOM_LM_TRIGGER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

    SELECT COUNT(*)
    FROM JAI_OM_LC_HDRS
    WHERE lc_number = pr_new.lc_number;

Line: 21

  SELECT LC_BALANCE_AMOUNT
  FROM JAI_OM_LC_HDRS
  WHERE LC_NUMBER = pr_new.LC_NUMBER;

Line: 58

    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;