APPS.ARP_BALANCE_CHECK dependencies on RA_CUSTOMER_TRX_LINES

Line 37: from ra_customer_trx_lines ctl

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

Line 1316: from ra_customer_trx_lines

1312: ra_customer_trx ct,
1313: (select customer_trx_id,
1314: sum(amount_due_remaining + nvl(chrg_amount_remaining, 0) + nvl(frt_adj_remaining, 0)) amount_due_remaining,
1315: sum(acctd_amount_due_remaining + nvl(chrg_acctd_amount_remaining, 0) + nvl(frt_adj_acctd_remaining, 0)) acctd_amount_due_remaining
1316: from ra_customer_trx_lines
1317: where customer_trx_id=decode(p_customer_trx_id,0,customer_trx_id,p_customer_trx_id)
1318: GROUP BY customer_trx_id) a
1319: where ct.upgrade_method='R12'
1320: and ct.customer_trx_id=decode(p_customer_trx_id,0,ct.customer_trx_id,p_customer_trx_id)