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'
54: AND lgd.latest_rec_flag = 'Y';
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'
114: AND lgd.latest_rec_flag = 'Y';