APPS.OKL_COMMON_FUNCTIONS SQL Statements

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

Line: 15

      SELECT SUM(amount)
      FROM   OKL_cure_payment_lines
      WHERE  chr_id = p_contract_id
      AND    status = 'CURES_IN_POSSESSION'; */

Line: 54

    SELECT 'Y'
    FROM    OKL_CURE_PAYMENT_LINES
    WHERE EXISTS (SELECT 1
                  FROM   OKL_CURE_PAYMENT_LINES
                  WHERE  status = 'CURES_IN_POSSESSION'
                  AND    cured_flag = 'Y'
                  AND    chr_id = p_chr_id);