Line 892: and EXISTS ( select '1' from ra_cust_trx_types rctt
888: and rct.org_id = l_ou_id
889: and rctl.customer_trx_id = rct.customer_trx_id
890: and rct.complete_flag = 'Y'
891: and rctl.customer_trx_line_id = rctlgd.customer_trx_line_id 892: and EXISTS ( select '1' from ra_cust_trx_types rctt 893: where rct.cust_trx_type_id = rctt.cust_trx_type_id
894: and rctt.type = 'CM')
895: and rctlgd.org_id = l_ou_id
896: and rctlgd.gl_date is not null