DBA Data[Home] [Help]

APPS.ARP_RW_ICR_PKG dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 886: FROM ar_interim_cash_receipt_lines

882: --
883: SELECT sum(nvl(amount_applied_from, nvl(payment_amount,0))), count(*)
884: INTO p_applied_amount_total,
885: p_applied_count_total
886: FROM ar_interim_cash_receipt_lines
887: WHERE cash_receipt_id = p_cr_id;
888: --
889: IF PG_DEBUG in ('Y', 'C') THEN
890: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );

Line 1166: FROM ar_interim_cash_receipt_lines icr

1162: END IF;
1163: --
1164: SELECT count(*)
1165: INTO l_count
1166: FROM ar_interim_cash_receipt_lines icr
1167: WHERE icr.cash_receipt_id = p_cr_id;
1168: --
1169: IF ( l_count = 0 ) THEN
1170: RETURN FALSE;