APPS.ARP_BALANCE_CHECK dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 32: from ra_cust_trx_line_gl_dist ctlgd

28: sum(decode(ctlgd.account_class,
29: 'REC', nvl(acctd_amount,0) * -1,
30: nvl(acctd_amount,0))) net_acctd_amount,
31: gl_date
32: from ra_cust_trx_line_gl_dist ctlgd
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'

Line 1311: ra_cust_trx_line_gl_dist gld,

1307:
1308: CURSOR C1(p_cust_trx_id NUMBER) IS
1309: select 'X'
1310: from ar_payment_schedules ps,
1311: ra_cust_trx_line_gl_dist gld,
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