APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 2545: -- sjalasut, modified the cursor to have khr_id referred to okl_txl_ap_inv_lns_all_b

2541: l_is_revolving_credit BOOLEAN := false;
2542: l_dummy NUMBER;
2543: l_principal_tot NUMBER := 0;
2544:
2545: -- sjalasut, modified the cursor to have khr_id referred to okl_txl_ap_inv_lns_all_b
2546: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements
2547: -- project.
2548: cursor c_disb_tot(p_creditline_id number) is
2549: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)

Line 2551: ,OKL_TXL_AP_INV_LNS_ALL_B TPL

2547: -- project.
2548: cursor c_disb_tot(p_creditline_id number) is
2549: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)
2550: FROM OKL_TRX_AP_INVOICES_B TAP
2551: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
2552: WHERE TAP.ID = TPL.TAP_ID
2553: AND TAP.TRX_STATUS_CODE = 'PROCESSED' -- push to AP
2554: AND TRUNC(DATE_INVOICED) <= TRUNC(p_trx_date)
2555: AND