APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 1439: ar_interim_cash_receipt_lines icrl

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

Line 1460: FROM ar_interim_cash_receipt_lines ln,

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

Line 1478: from ar_interim_cash_receipt_lines ln

1474: ,l_applied_count_total
1475: FROM (select sum(decode(payment_schedule_id,-4,1,0)) CLAIM
1476: , SUM(decode(payment_schedule_id,-1,1,0)) ON_ACC
1477: , sum(decode(sign(payment_schedule_id),1,1,0)) TRX
1478: from ar_interim_cash_receipt_lines ln
1479: where ln.batch_id = p_batch_id
1480: );
1481:
1482: --