APPS.ARP_TRX_SUM_UTIL dependencies on RA_CUSTOMER_TRX

Line 49: FROM ra_customer_trx ct,

45: IF (nvl(p_mode, 'SUM') = 'SUM')
46: THEN
47: SELECT nvl(sum(lgd.amount), 0)
48: INTO l_sum_value
49: FROM ra_customer_trx ct,
50: ra_cust_trx_line_gl_dist lgd
51: WHERE ct.customer_trx_id = lgd.customer_trx_id
52: AND ct.batch_id = p_batch_id
53: AND lgd.account_class = 'REC'

Line 58: FROM ra_customer_trx ct

54: AND lgd.latest_rec_flag = 'Y';
55: ELSE
56: SELECT count(*)
57: INTO l_sum_value
58: FROM ra_customer_trx ct
59: WHERE ct.batch_id = p_batch_id;
60: END IF;
61:
62: RETURN(l_sum_value);

Line 109: FROM ra_customer_trx ct,

105:
106: /* get actual_amount */
107: SELECT nvl(sum(lgd.amount), 0)
108: INTO l_actual_amount
109: FROM ra_customer_trx ct,
110: ra_cust_trx_line_gl_dist lgd
111: WHERE ct.customer_trx_id = lgd.customer_trx_id
112: AND ct.batch_id = p_batch_id
113: AND lgd.account_class = 'REC'

Line 119: FROM ra_customer_trx ct

115:
116: /* get actual count */
117: SELECT count(*)
118: INTO l_actual_count
119: FROM ra_customer_trx ct
120: WHERE ct.batch_id = p_batch_id;
121:
122: END get_batch_summary_all;
123: