206: INTO ln_amount
207: FROM (SELECT 'T' trx_type
208: ,SUM(NVL(rctld.acctd_amount,0)) accounted_amount
209: FROM ra_customer_trx rct
210: ,ra_cust_trx_line_gl_dist_all rctld
211: ,ra_cust_trx_types_all rctt
212: WHERE rct.customer_trx_id = rctld.customer_trx_id
213: AND rct.cust_trx_type_id = rctt.cust_trx_type_id
214: AND rct.org_id = rctt.org_id