APPS.OKL_BPD_CREDIT_CHECK_PVT SQL Statements

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

Line: 22

  SELECT TAP.AMOUNT,
         TAP.KHR_ID
FROM   OKL_TRX_AP_INVOICES_B TAP
WHERE  TAP.TRX_STATUS_CODE in ('APPROVED','PROCESSED') -- push to AP
AND    TAP.FUNDING_TYPE_CODE IS NOT NULL
--AND    TRUNC(DATE_INVOICED) <= TRUNC(p_trx_date)
;

Line: 33

select 1 -- Revloving line of credit line
from   okl_k_headers REV
where  rev.id = p_creditline_id
and    REV.REVOLVING_CREDIT_YN = 'Y'
;

Line: 40

SELECT
--  NVL(SUM(NVL(PS.AMOUNT_APPLIED,0)),0)
  NVL(PS.AMOUNT_APPLIED,0),
  CN.ID KHR_ID
FROM
  AR_PAYMENT_SCHEDULES_ALL PS,
  OKL_CNSLD_AR_STRMS_B ST,
  OKL_STRM_TYPE_TL SM,
  OKC_K_HEADERS_B CN
WHERE
  PS.CLASS IN ('INV') AND
  ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND
  SM.ID = ST.STY_ID AND
  SM.LANGUAGE = USERENV ('LANG') AND
  CN.ID = ST.KHR_ID     AND
  SM.NAME = 'PRINCIPAL PAYMENT' AND
  TRUNC(NVL(PS.TRX_DATE, SYSDATE)) <= TRUNC(p_trx_date)
AND
;