DBA Data[Home] [Help]

APPS.OKL_BPD_CREDIT_CHECK_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 24: FROM OKL_TRX_AP_INVOICES_B TAP

20: cursor c_disb_tot is
21: -- SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)
22: SELECT TAP.AMOUNT,
23: TAP.KHR_ID
24: FROM OKL_TRX_AP_INVOICES_B TAP
25: WHERE TAP.TRX_STATUS_CODE in ('APPROVED','PROCESSED') -- push to AP
26: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
27: --AND TRUNC(DATE_INVOICED) <= TRUNC(p_trx_date)
28: ;