301:
302: /*
303: SELECT (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
304: FROM ar_cash_receipts_all ar,
305: okl_receipt_applications_uv app,
306: okc_k_headers_b chr
307: WHERE chr.id = p_contract_id
308: AND ar.cash_receipt_id = app.cash_receipt_id
309: AND ar.pay_from_customer = p_customer_id
313: -- Modified cursor for bug 11810605
314: /*select
315: (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
316: FROM ar_cash_receipts_all ar,
317: okl_receipt_applications_uv app
318: WHERE
319: ar.cash_receipt_id = app.cash_receipt_id
320: AND ar.pay_from_customer = p_customer_id
321: AND customer_trx_id in
329: -- Added for performance issue 13082893
330: select
331: (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
332: FROM ar_cash_receipts_all ar,
333: okl_receipt_applications_uv app
334: WHERE
335: ar.cash_receipt_id = app.cash_receipt_id
336: AND ar.pay_from_customer = p_customer_id
337: AND exists