DBA Data[Home] [Help]

APPS.ARP_TRX_SUM_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 50: ra_cust_trx_line_gl_dist lgd

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

Line 110: ra_cust_trx_line_gl_dist lgd

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