DBA Data[Home] [Help]

APPS.JE_IL_TAX_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 678: xla_distribution_links xdln,

674: SELECT xdln.event_id event,
675: -- SUM(xdln.unrounded_accounted_dr) pay_amount Commented for bug 10279386
676: SUM(nvl(xdln.unrounded_accounted_dr,0)) - SUM(nvl(xdln.unrounded_accounted_cr,0)) pay_amount --modified for bug10279386
677: FROM ap_invoice_distributions_all aid ,
678: xla_distribution_links xdln,
679: xla_ae_headers xlah
680: WHERE aid.invoice_id = cn_invoice_id
681: AND aid.line_type_lookup_code = 'AWT'
682: AND xlah.application_id = xdln.application_id

Line 769: xla_distribution_links xdln,

765:
766: BEGIN
767: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
768: FROM ap_invoice_distributions_all aid ,
769: xla_distribution_links xdln,
770: xla_ae_headers xlah
771: WHERE aid.invoice_id = ln_invoice_id
772: AND aid.line_type_lookup_code <> 'AWT'
773: AND xdln.event_id = aid.accounting_event_id