DBA Data[Home] [Help]

APPS.ARP_BALANCE_CHECK dependencies on RA_CUSTOMER_TRX_LINES

Line 36: from ra_customer_trx_lines ctl

32: where ctlgd.customer_trx_id = p_cust_trx_id
33: and ctlgd.account_set_flag = 'N'
34: and ctlgd.posting_control_id = -3
35: and not exists (select 'x'
36: from ra_customer_trx_lines ctl
37: where ctl.customer_trx_id = p_customer_trx_id
38: and ctl.autorule_complete_flag||'' = 'N'
39: group by ctl.customer_trx_id)
40: group by customer_trx_id, gl_date;