DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 2608: FROM ar_payment_schedules_all

2604: SELECT amount_due_remaining,
2605: amount_due_original
2606: INTO l_amt_due_remaining,
2607: l_amt_due_original
2608: FROM ar_payment_schedules_all
2609: WHERE cash_receipt_id = p_cash_receipt_id;
2610:
2611: EXCEPTION
2612: WHEN no_data_found THEN

Line 2624: ar_payment_schedules_all ps

2620: SUM(ra.amount_applied_from)
2621: INTO l_amt_app_prev,
2622: l_amt_app_from_prev
2623: FROM ar_receivable_applications_all ra,
2624: ar_payment_schedules_all ps
2625: WHERE ra.cash_receipt_id = p_cash_receipt_id
2626: AND ra.status = 'APP'
2627: AND ra.display = 'Y'
2628: AND ra.trans_to_receipt_rate = p_trans_to_receipt_rate