DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 94: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

90: ,x_return_status OUT NOCOPY VARCHAR2
91: )
92: IS
93: l_invoice_balance_due NUMBER;
94: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
95:
96: CURSOR csr_invoice_balance(cv_trx_id IN NUMBER) IS
97: SELECT SUM(amount_due_remaining), trx_number
98: FROM ar_payment_schedules pay