DBA Data[Home] [Help]

APPS.JE_IL_TAX_PKG dependencies on XLA_AE_LINES

Line 608: xla_ae_lines xdln ,

604: AND a.check_id = pn_check_id
605: AND a.accounting_date >= pd_start_date
606: AND a.accounting_date <= pd_end_date
607: AND a.reversal_inv_pmt_id IS NULL) aip,
608: xla_ae_lines xdln ,
609: xla_ae_headers xlah
610: WHERE aip.accounting_event_id = xlah.event_id
611: AND xlah.application_id = xdln.application_id
612: AND xlah.ae_header_id = xdln.ae_header_id

Line 629: xla_ae_lines xdln ,

625: AND a.check_id = pn_check_id
626: AND a.accounting_date >= pd_start_date
627: AND a.accounting_date <= pd_end_date
628: AND a.reversal_inv_pmt_id IS NOT NULL) aip,
629: xla_ae_lines xdln ,
630: xla_ae_headers xlah
631: WHERE aip.accounting_event_id = xlah.event_id
632: AND xlah.application_id = xdln.application_id
633: AND xlah.ae_header_id = xdln.ae_header_id

Line 643: FROM xla_ae_lines xdln,

639:
640: CURSOR c_get_payevent_awt(cn_invoice_id NUMBER, cn_event_id NUMBER) IS
641: SELECT xlah.event_id event,
642: SUM(nvl(xdln.unrounded_accounted_cr,0)) - SUM(nvl(xdln.unrounded_accounted_dr,0)) pay_amount --modified for bug10262743
643: FROM xla_ae_lines xdln,
644: xla_ae_headers xlah ,
645: ap_invoice_payments_all aip
646: WHERE aip.invoice_id = cn_invoice_id
647: AND aip.check_id = pn_check_id