APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1645: FROM ar_receivable_applications ra,

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

Line 1666: FROM ar_receivable_applications ra

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)
1666: FROM ar_receivable_applications ra
1667: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1668: AND ra.status = 'ACC'
1669: AND ra.display = 'Y'); -- Fix 1178963
1670: --

Line 1701: FROM ar_receivable_applications ra

1697: AND crh.first_posted_record_flag = 'Y'
1698: AND crh.batch_id = p_batch_id
1699: AND cr.amount = (SELECT
1700: sum(ra.amount_applied)
1701: FROM ar_receivable_applications ra
1702: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1703: AND ra.status = 'OTHER ACC'
1704: AND ra.applied_payment_schedule_id + 0 = -4
1705: AND ra.display = 'Y');

Line 1730: FROM ar_receivable_applications ra

1726: AND crh.first_posted_record_flag = 'Y'
1727: AND crh.batch_id = p_batch_id
1728: AND cr.amount = (SELECT
1729: sum(ra.amount_applied)
1730: FROM ar_receivable_applications ra
1731: WHERE ra.cash_receipt_id = cr.cash_receipt_id
1732: AND ra.status = 'OTHER ACC'
1733: AND ra.applied_payment_schedule_id + 0 = -7
1734: AND ra.display = 'Y');