APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 479: FROM okl_trx_ap_invoices_b a,

475: -- Cursor to get the total amount already disbursed to the investor
476: CURSOR c_tot_amt_disbursed (p_ia_id NUMBER, p_vendor_site_id NUMBER, p_fee_line_id NUMBER)
477: IS
478: SELECT NVL(SUM(b.amount),0)
479: FROM okl_trx_ap_invoices_b a,
480: okl_txl_ap_inv_lns_b b
481: WHERE a.id = b.tap_id
482: AND a.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED')
483: AND b.amount > 0

Line 2220: UPDATE okl_trx_ap_invoices_b

2216: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 39 ### ');
2217: -- FOR i IN lsm_error_log_table.FIRST..lsm_error_log_table.LAST LOOP
2218: FOR i IN tld_error_log_table.FIRST..tld_error_log_table.LAST LOOP
2219: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 40 ### ');
2220: UPDATE okl_trx_ap_invoices_b
2221: SET trx_status_code = 'ERROR'
2222: WHERE Id = tld_error_log_table(i).tap_id;
2223:
2224: END LOOP;