DBA Data[Home] [Help]

APPS.CSTPMRGL dependencies on RA_CUST_TRX_TYPES

Line 912: and EXISTS ( select '1' from ra_cust_trx_types rctt

908: and rct.org_id = l_ou_id
909: and rctl.customer_trx_id = rct.customer_trx_id
910: and rct.complete_flag = 'Y'
911: and rctl.customer_trx_line_id = rctlgd.customer_trx_line_id
912: and EXISTS ( select '1' from ra_cust_trx_types rctt
913: where rct.cust_trx_type_id = rctt.cust_trx_type_id
914: and rctt.type = 'CM')
915: and rctlgd.org_id = l_ou_id
916: and rctlgd.gl_date is not null