APPS.ARP_CTL_SUM_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 49: FROM ra_customer_trx_lines

45: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
46: NVL( SUM( NVL(extended_amount, 0 ) ), 0)
47: INTO p_amount_total,
48: p_amount_total_rtot_db
49: FROM ra_customer_trx_lines
50: WHERE customer_trx_id = p_customer_trx_id;
51: ELSE
52: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
53: NVL( SUM( NVL(extended_amount, 0 ) ), 0)

Line 56: FROM ra_customer_trx_lines

52: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
53: NVL( SUM( NVL(extended_amount, 0 ) ), 0)
54: INTO p_amount_total,
55: p_amount_total_rtot_db
56: FROM ra_customer_trx_lines
57: WHERE customer_trx_id = p_customer_trx_id
58: AND line_type = p_line_type;
59:
60: -- arp_util.debug('arp_ctl_sum_pkg.select_summary()-');