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: ;