DBA Data[Home] [Help]

APPS.CSTPMRGL dependencies on RA_CUST_TRX_TYPES

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