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 2262: ra_cust_trx_line_gl_dist gld,

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

Line 3531: FROM ra_cust_trx_line_gl_dist gld,

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

Line 3561: FROM ra_cust_trx_line_gl_dist gld,

3557: END IF;
3558:
3559: SELECT max(gld.collected_tax_ccid) ae_collected_tax_ccid
3560: INTO l_collected_ccid
3561: FROM ra_cust_trx_line_gl_dist gld,
3562: ra_customer_trx_lines ctl
3563: --ra_customer_trx_lines ctl1
3564: WHERE ctl.customer_trx_id = p_customer_trx_id
3565: AND gld.customer_trx_id = ctl.customer_trx_id