APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_INTERIM_CASH_RECEIPTS

Line 527: -- in the AR_INTERIM_CASH_RECEIPTS table

523: --
524: arp_cr_batches_pkg.set_to_dummy( l_batch_rec );
525: --
526: -- determine if the batch has any unposted quick cash receipts
527: -- in the AR_INTERIM_CASH_RECEIPTS table
528: --
529: SELECT NVL(SUM(DECODE
530: (
531: icr.status,

Line 538: FROM ar_interim_cash_receipts icr,

534: 1
535: )),0),
536: NVL(SUM( icr.amount ), 0 )
537: INTO l_icr_count, l_icr_amount
538: FROM ar_interim_cash_receipts icr,
539: ar_batches b
540: WHERE b.batch_id = p_batch_id
541: AND b.batch_id = icr.batch_id(+);
542: --

Line 1424: FROM ar_interim_cash_receipts icr

1420: l_unapplied_amount_total,
1421: l_unapplied_count_total,
1422: p_unidentified_amount_total,
1423: p_unidentified_count_total
1424: FROM ar_interim_cash_receipts icr
1425: WHERE icr.batch_id = p_batch_id;
1426: --
1427: --
1428: --

Line 1438: FROM ar_interim_cash_receipts icr,

1434: INTO l_applied_amount_total,
1435: l_unapplied_amount_total,
1436: l_claim_amount_total_lines,
1437: l_onacct_amount_total_lines
1438: FROM ar_interim_cash_receipts icr,
1439: ar_interim_cash_receipt_lines icrl
1440: WHERE icrl.cash_receipt_id = icr.cash_receipt_id
1441: AND icr.batch_id = p_batch_id;
1442: --

Line 1461: ar_interim_cash_receipts rec

1457: 1, 1, '' ))
1458: INTO l_applied_count_total,
1459: l_unapplied_count_total
1460: FROM ar_interim_cash_receipt_lines ln,
1461: ar_interim_cash_receipts rec
1462: WHERE rec.batch_id = p_batch_id
1463: AND rec.cash_receipt_id = ln.cash_receipt_id
1464: GROUP BY
1465: rec.cash_receipt_id,