APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 494: FROM okl_trx_ap_invoices_b a,

490: -- Cursor to get the total amount already disbursed to the investor
491: CURSOR c_tot_amt_disbursed (p_ia_id NUMBER, p_vendor_site_id NUMBER, p_fee_line_id NUMBER)
492: IS
493: SELECT NVL(SUM(b.amount),0)
494: FROM okl_trx_ap_invoices_b a,
495: okl_txl_ap_inv_lns_b b
496: WHERE a.id = b.tap_id
497: AND a.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED')
498: AND b.amount > 0

Line 2308: UPDATE okl_trx_ap_invoices_b

2304: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 39 ### ');
2305: -- FOR i IN lsm_error_log_table.FIRST..lsm_error_log_table.LAST LOOP
2306: FOR i IN tld_error_log_table.FIRST..tld_error_log_table.LAST LOOP
2307: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 40 ### ');
2308: UPDATE okl_trx_ap_invoices_b
2309: SET trx_status_code = 'ERROR'
2310: WHERE Id = tld_error_log_table(i).tap_id;
2311:
2312: END LOOP;