APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_CASH_RECEIPTS

Line 615: ar_cash_receipts cr,

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
619: AND crh.first_posted_record_flag(+) = 'Y'

Line 1618: FROM ar_cash_receipts cr,

1614: p_unidentified_amount_total,
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;

Line 1660: FROM ar_cash_receipts cr,

1656: Begin
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

Line 1694: FROM ar_cash_receipts cr,

1690: -- Bug 3590163: disabled index on applied_payment_schedule_id
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

Line 1723: FROM ar_cash_receipts cr,

1719: -- Bug 3590163: disabled index on applied_payment_schedule_id
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