DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 120: , ar_payment_schedules pay

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'

Line 599: , ar_payment_schedules pay

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'