APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 1491: ar_interim_cash_receipt_lines icrl

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: --
1495: -- Add to unapplied count if all amounts of receipt has not been paid off

Line 1512: FROM ar_interim_cash_receipt_lines ln,

1508: COUNT( DECODE( SIGN(rec.amount - NVL( SUM( nvl(ln.amount_applied_from, ln.payment_amount) ) , 0 )),
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

Line 1530: from ar_interim_cash_receipt_lines ln

1526: --,l_applied_count_total
1527: FROM (select sum(decode(payment_schedule_id,-4,1,0)) CLAIM
1528: , SUM(decode(payment_schedule_id,-1,1,0)) ON_ACC
1529: , sum(decode(sign(payment_schedule_id),1,1,0)) TRX
1530: from ar_interim_cash_receipt_lines ln
1531: where ln.batch_id = p_batch_id
1532: );
1533:
1534: --