APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_INTERIM_CASH_RECEIPTS

Line 532: -- in the AR_INTERIM_CASH_RECEIPTS table

528: --
529: arp_cr_batches_pkg.set_to_dummy( l_batch_rec );
530: --
531: -- determine if the batch has any unposted quick cash receipts
532: -- in the AR_INTERIM_CASH_RECEIPTS table
533: --
534: SELECT NVL(SUM(DECODE
535: (
536: icr.status,

Line 543: FROM ar_interim_cash_receipts icr,

539: 1
540: )),0),
541: NVL(SUM( icr.amount ), 0 )
542: INTO l_icr_count, l_icr_amount
543: FROM ar_interim_cash_receipts icr,
544: ar_batches b
545: WHERE b.batch_id = p_batch_id
546: AND b.batch_id = icr.batch_id(+);
547: --

Line 1476: FROM ar_interim_cash_receipts icr

1472: l_unapplied_amount_total,
1473: l_unapplied_count_total,
1474: p_unidentified_amount_total,
1475: p_unidentified_count_total
1476: FROM ar_interim_cash_receipts icr
1477: WHERE icr.batch_id = p_batch_id;
1478: --
1479: --
1480: --

Line 1490: FROM ar_interim_cash_receipts icr,

1486: INTO l_applied_amount_total,
1487: l_unapplied_amount_total,
1488: l_claim_amount_total_lines,
1489: l_onacct_amount_total_lines
1490: FROM ar_interim_cash_receipts icr,
1491: ar_interim_cash_receipt_lines icrl
1492: WHERE icrl.cash_receipt_id = icr.cash_receipt_id
1493: AND icr.batch_id = p_batch_id;
1494: --

Line 1513: ar_interim_cash_receipts rec

1509: 1, 1, '' ))
1510: INTO l_applied_count_total,
1511: l_unapplied_count_total
1512: FROM ar_interim_cash_receipt_lines ln,
1513: ar_interim_cash_receipts rec
1514: WHERE rec.batch_id = p_batch_id
1515: AND rec.cash_receipt_id = ln.cash_receipt_id
1516: GROUP BY
1517: rec.cash_receipt_id,