APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1702: FROM ar_receivable_applications ra,

1698: l_unapplied_amount_total,
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;

Line 1723: FROM ar_receivable_applications ra

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)
1723: FROM ar_receivable_applications ra
1724: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1725: AND ra.status = 'ACC'
1726: AND ra.display = 'Y'); -- Fix 1178963
1727: --

Line 1758: FROM ar_receivable_applications ra

1754: AND crh.first_posted_record_flag = 'Y'
1755: AND crh.batch_id = p_batch_id
1756: AND cr.amount = (SELECT
1757: sum(ra.amount_applied)
1758: FROM ar_receivable_applications ra
1759: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1760: AND ra.status = 'OTHER ACC'
1761: AND ra.applied_payment_schedule_id + 0 = -4
1762: AND ra.display = 'Y');

Line 1787: FROM ar_receivable_applications ra

1783: AND crh.first_posted_record_flag = 'Y'
1784: AND crh.batch_id = p_batch_id
1785: AND cr.amount = (SELECT
1786: sum(ra.amount_applied)
1787: FROM ar_receivable_applications ra
1788: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1789: AND ra.status = 'OTHER ACC'
1790: AND ra.applied_payment_schedule_id + 0 = -7
1791: AND ra.display = 'Y');