DBA Data[Home] [Help]

APPS.OKL_CURE_CALC_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 149: ,ar_receivable_applications ara

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

Line 165: ,ar_receivable_applications ara

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