DBA Data[Home] [Help]

APPS.ARP_RW_ICR_PKG dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 874: FROM ar_interim_cash_receipt_lines

870: --
871: SELECT sum(nvl(amount_applied_from, nvl(payment_amount,0))), count(*)
872: INTO p_applied_amount_total,
873: p_applied_count_total
874: FROM ar_interim_cash_receipt_lines
875: WHERE cash_receipt_id = p_cr_id;
876: --
877: IF PG_DEBUG in ('Y', 'C') THEN
878: arp_util.debug( 'arp_rw_icr_pkg.get_applied_amount_total()-' );

Line 1154: FROM ar_interim_cash_receipt_lines icr

1150: END IF;
1151: --
1152: SELECT count(*)
1153: INTO l_count
1154: FROM ar_interim_cash_receipt_lines icr
1155: WHERE icr.cash_receipt_id = p_cr_id;
1156: --
1157: IF ( l_count = 0 ) THEN
1158: RETURN FALSE;