145: /*cursor c_get_received_amounts (p_cure_amount_id IN NUMBER) is
146: select sum(ara.amount_applied)
147: from ar_payment_schedules ps1,
148: okl_cnsld_ar_strms_b st1
149: ,ar_receivable_applications ara
150: ,okl_xtl_sell_invs_v xls
151: ,okl_txl_ar_inv_lns_v til
152: ,okl_trx_ar_invoices_v tai
153: where st1.receivables_invoice_id = ps1.customer_trx_id
161: cursor c_get_received_amounts (p_cure_amount_id IN NUMBER) is
162: select sum(ara.amount_applied)
163: from ar_payment_schedules ps1,
164: okl_bpd_tld_ar_lines_v st1
165: ,ar_receivable_applications ara
166: --,okl_xtl_sell_invs_v xls
167: ,okl_txl_ar_inv_lns_v til
168: ,okl_trx_ar_invoices_v tai
169: where st1.customer_trx_id = ps1.customer_trx_id