296: , pay.trx_number
297: , rec.apply_date
298: , rec.amount_applied
299: , pay.status
300: FROM ar_receivable_applications rec
301: , ar_payment_schedules pay
302: WHERE rec.cash_receipt_id = cv_cash_receipt_id
303: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
304: AND pay.customer_trx_id = cv_customer_trx_id
345: , pay.trx_number
346: , rec.apply_date
347: , rec.amount_applied
348: , pay.status
349: FROM ar_receivable_applications rec
350: , ar_payment_schedules pay
351: WHERE rec.cash_receipt_id = cv_cash_receipt_id
352: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
353: AND pay.payment_schedule_id = -1
361: , pay.trx_number
362: , rec.apply_date
363: , rec.amount_applied
364: , pay.status
365: FROM ar_receivable_applications rec
366: , ar_payment_schedules pay
367: WHERE rec.cash_receipt_id = cv_cash_receipt_id
368: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
369: AND pay.payment_schedule_id = -3