APPS.ARP_RECONCILE dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 347: from ra_cust_trx_line_gl_dist gld

343: select 'Y'
344: into l_def_flag
345: from dual
346: where exists (select 'x'
347: from ra_cust_trx_line_gl_dist gld
348: where gld.account_class = 'TAX'
349: and gld.customer_trx_id = p_customer_trx_id
350: and gld.collected_tax_ccid IS NOT NULL
351: );

Line 2263: ra_cust_trx_line_gl_dist gld,

2259: p_ae_sys_rec.base_precision ,
2260: p_ae_sys_rec.base_min_acc_unit),
2261: '')) taxable_acctd_amount
2262: FROM ra_customer_trx ct ,
2263: ra_cust_trx_line_gl_dist gld,
2264: ra_customer_trx_lines ctl,
2265: ra_customer_trx_lines ctl1
2266: where ct.customer_trx_id = p_customer_trx_id
2267: and p_calling_point IN ('TRAN', 'BLTR')

Line 3532: FROM ra_cust_trx_line_gl_dist gld,

3528: --there is no concept of tax group id and location segment id is no longer
3529: --used - it is all vat tax id on TAX line type
3530: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3531: INTO l_collected_ccid
3532: FROM ra_cust_trx_line_gl_dist gld,
3533: ra_customer_trx_lines ctl
3534: --ra_customer_trx_lines ctl1
3535: WHERE ctl.customer_trx_id = p_customer_trx_id
3536: AND gld.customer_trx_id = ctl.customer_trx_id