APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

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

2594: l_is_revolving_credit BOOLEAN := false;
2595: l_dummy NUMBER;
2596: l_principal_tot NUMBER := 0;
2597:
2598: -- sjalasut, modified the cursor to have khr_id referred to okl_txl_ap_inv_lns_all_b
2599: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements
2600: -- project.
2601: cursor c_disb_tot(p_creditline_id number) is
2602: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)

Line 2604: ,OKL_TXL_AP_INV_LNS_ALL_B TPL

2600: -- project.
2601: cursor c_disb_tot(p_creditline_id number) is
2602: SELECT NVL(SUM(NVL(TAP.AMOUNT,0)),0)
2603: FROM OKL_TRX_AP_INVOICES_B TAP
2604: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
2605: WHERE TAP.ID = TPL.TAP_ID
2606: AND TAP.TRX_STATUS_CODE = 'PROCESSED' -- push to AP
2607: AND TRUNC(DATE_INVOICED) <= TRUNC(p_trx_date)
2608: AND