APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 614: FROM ar_cash_receipt_history crh,

610: 'OOB'
611: )
612: )
613: INTO l_batch_status
614: FROM ar_cash_receipt_history crh,
615: ar_cash_receipts cr,
616: ar_batches b
617: WHERE b.batch_id = p_batch_id
618: AND crh.batch_id(+) = b.batch_id

Line 1619: ar_cash_receipt_history crh

1615: p_unidentified_count_total,
1616: l_misc_amount_total,
1617: l_misc_count_total
1618: FROM ar_cash_receipts cr,
1619: ar_cash_receipt_history crh
1620: WHERE cr.cash_receipt_id = crh.cash_receipt_id
1621: AND crh.first_posted_record_flag = 'Y'
1622: AND crh.batch_id = p_batch_id;
1623: --

Line 1646: ar_cash_receipt_history crh

1642: l_on_account_amount_total,
1643: l_claim_amount_total,
1644: l_prepayment_amount_total
1645: FROM ar_receivable_applications ra,
1646: ar_cash_receipt_history crh
1647: WHERE ra.cash_receipt_id = crh.cash_receipt_id
1648: AND crh.first_posted_record_flag = 'Y'
1649: AND crh.batch_id = p_batch_id;
1650: --

Line 1661: ar_cash_receipt_history crh

1657: --
1658: SELECT nvl(count(cr.cash_receipt_id), 0)
1659: INTO l_on_account_count_total
1660: FROM ar_cash_receipts cr,
1661: ar_cash_receipt_history crh
1662: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1663: AND crh.first_posted_record_flag = 'Y'
1664: AND crh.batch_id = p_batch_id
1665: AND cr.amount = (SELECT sum(ra.amount_applied)

Line 1695: ar_cash_receipt_history crh

1691:
1692: SELECT nvl(count(cr.cash_receipt_id), 0)
1693: INTO l_claim_count_total
1694: FROM ar_cash_receipts cr,
1695: ar_cash_receipt_history crh
1696: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1697: AND crh.first_posted_record_flag = 'Y'
1698: AND crh.batch_id = p_batch_id
1699: AND cr.amount = (SELECT

Line 1724: ar_cash_receipt_history crh

1720:
1721: SELECT nvl(count(cr.cash_receipt_id), 0)
1722: INTO l_prepayment_count_total
1723: FROM ar_cash_receipts cr,
1724: ar_cash_receipt_history crh
1725: WHERE crh.cash_receipt_id = cr.cash_receipt_id
1726: AND crh.first_posted_record_flag = 'Y'
1727: AND crh.batch_id = p_batch_id
1728: AND cr.amount = (SELECT