APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_CASH_RECEIPTS

Line 621: ar_cash_receipts cr,

617: )
618: )
619: INTO l_batch_status
620: FROM ar_cash_receipt_history crh,
621: ar_cash_receipts cr,
622: ar_batches b
623: WHERE b.batch_id = p_batch_id
624: AND crh.batch_id(+) = b.batch_id
625: AND crh.first_posted_record_flag(+) = 'Y'

Line 1674: FROM ar_cash_receipts cr,

1670: p_unidentified_amount_total,
1671: p_unidentified_count_total,
1672: l_misc_amount_total,
1673: l_misc_count_total
1674: FROM ar_cash_receipts cr,
1675: ar_cash_receipt_history crh
1676: WHERE cr.cash_receipt_id = crh.cash_receipt_id
1677: AND crh.first_posted_record_flag = 'Y'
1678: AND crh.batch_id = p_batch_id;

Line 1717: FROM ar_cash_receipts cr,

1713: Begin
1714: --
1715: SELECT nvl(count(cr.cash_receipt_id), 0)
1716: INTO l_on_account_count_total
1717: FROM ar_cash_receipts cr,
1718: ar_cash_receipt_history crh
1719: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1720: AND crh.first_posted_record_flag = 'Y'
1721: AND crh.batch_id = p_batch_id

Line 1751: FROM ar_cash_receipts cr,

1747: -- Bug 3590163: disabled index on applied_payment_schedule_id
1748:
1749: SELECT nvl(count(cr.cash_receipt_id), 0)
1750: INTO l_claim_count_total
1751: FROM ar_cash_receipts cr,
1752: ar_cash_receipt_history crh
1753: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1754: AND crh.first_posted_record_flag = 'Y'
1755: AND crh.batch_id = p_batch_id

Line 1780: FROM ar_cash_receipts cr,

1776: -- Bug 3590163: disabled index on applied_payment_schedule_id
1777:
1778: SELECT nvl(count(cr.cash_receipt_id), 0)
1779: INTO l_prepayment_count_total
1780: FROM ar_cash_receipts cr,
1781: ar_cash_receipt_history crh
1782: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1783: AND crh.first_posted_record_flag = 'Y'
1784: AND crh.batch_id = p_batch_id