116: , rec.customer_reference
117: , rec.amount_applied
118: , pay.amount_due_remaining
119: FROM ar_receivable_applications rec
120: , ar_payment_schedules pay
121: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
122: AND rec.cash_receipt_id = cv_cash_receipt_id
123: AND pay.customer_trx_id = cv_customer_trx_id
124: AND rec.application_ref_type = 'CLAIM'
595: , rec.customer_reference
596: , rec.amount_applied
597: , pay.amount_due_remaining
598: FROM ar_receivable_applications rec
599: , ar_payment_schedules pay
600: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
601: AND rec.cash_receipt_id = cv_cash_receipt_id
602: AND pay.customer_trx_id = cv_customer_trx_id
603: AND rec.application_ref_type = 'CLAIM'