APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 620: FROM ar_cash_receipt_history crh,

616: 'OOB'
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

Line 1675: ar_cash_receipt_history crh

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;
1679: --

Line 1703: ar_cash_receipt_history crh

1699: l_on_account_amount_total,
1700: l_claim_amount_total,
1701: l_prepayment_amount_total
1702: FROM ar_receivable_applications ra,
1703: ar_cash_receipt_history crh
1704: WHERE ra.cash_receipt_id = crh.cash_receipt_id
1705: AND crh.first_posted_record_flag = 'Y'
1706: AND crh.batch_id = p_batch_id;
1707: --

Line 1718: ar_cash_receipt_history crh

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
1722: AND cr.amount = (SELECT sum(ra.amount_applied)

Line 1752: ar_cash_receipt_history crh

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
1756: AND cr.amount = (SELECT

Line 1781: ar_cash_receipt_history crh

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
1785: AND cr.amount = (SELECT