APPS.ARP_CTL_SUM_PKG dependencies on RA_CUSTOMER_TRX

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()-');

Line 99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

95: | |
96: +===========================================================================*/
97:
98: FUNCTION get_summary(
99: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
100: p_line_type IN varchar2
101: ) return NUMBER IS
102:
103: p_amount_total NUMBER;