DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on AR_RECEIVABLE_APPLICATIONS

Line 913: -- and ar_receivable_applications/ar_misc_cash_distributions

909:
910: -- If exchange rate has been changed
911: -- Insert a record into ar_rate_adjustments
912: -- Call arplbrad.main() to take care the ar_cash_receipts, ar_payment_schedules
913: -- and ar_receivable_applications/ar_misc_cash_distributions
914: --
915: -- 17-MAY-1999 J Rautiainen truncation exits on exchange rate so the comparison
916: -- was changed from comparing exchange rates to comparing accounted amounts in order
917: -- to fix bug 874052.

Line 2436: ar_receivable_applications ra

2432:
2433: CURSOR applied_to_reserved_br_cur IS
2434: SELECT 'Y'
2435: FROM ar_payment_schedules ps,
2436: ar_receivable_applications ra
2437: WHERE ra.cash_receipt_id = p_cash_receipt_id
2438: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2439: AND ps.reserved_type IS NOT NULL
2440: AND ps.reserved_value IS NOT NULL

Line 2446: FROM ar_receivable_applications ra

2442: AND ra.display = 'Y';
2443:
2444: CURSOR applied_to_std_cur IS
2445: SELECT 'Y'
2446: FROM ar_receivable_applications ra
2447: WHERE ra.cash_receipt_id = p_cash_receipt_id
2448: AND ra.applied_payment_schedule_id = -2
2449: AND ra.display = 'Y';
2450: