DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on AR_RECEIVABLE_APPLICATIONS

Line 714: -- and ar_receivable_applications/ar_misc_cash_distributions

710:
711: -- If exchange rate has been changed
712: -- Insert a record into ar_rate_adjustments
713: -- Call arplbrad.main() to take care the ar_cash_receipts, ar_payment_schedules
714: -- and ar_receivable_applications/ar_misc_cash_distributions
715: --
716: -- 17-MAY-1999 J Rautiainen truncation exits on exchange rate so the comparison
717: -- was changed from comparing exchange rates to comparing accounted amounts in order
718: -- to fix bug 874052.

Line 2003: ar_receivable_applications ra

1999:
2000: CURSOR applied_to_reserved_br_cur IS
2001: SELECT 'Y'
2002: FROM ar_payment_schedules ps,
2003: ar_receivable_applications ra
2004: WHERE ra.cash_receipt_id = p_cash_receipt_id
2005: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2006: AND ps.reserved_type IS NOT NULL
2007: AND ps.reserved_value IS NOT NULL

Line 2013: FROM ar_receivable_applications ra

2009: AND ra.display = 'Y';
2010:
2011: CURSOR applied_to_std_cur IS
2012: SELECT 'Y'
2013: FROM ar_receivable_applications ra
2014: WHERE ra.cash_receipt_id = p_cash_receipt_id
2015: AND ra.applied_payment_schedule_id = -2
2016: AND ra.display = 'Y';
2017: