APPS.JE_IL_TAX_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 101: xla_distribution_links xdln ,

97: MIN(aip.invoice_id) invoice_id
98: FROM ap_invoice_distributions aid ,
99: ap_invoice_payments aip ,
100: ap_payment_hist_dists payh ,
101: xla_distribution_links xdln ,
102: xla_ae_headers xlah
103: WHERE aip.invoice_id = pn_invoice_id
104: AND aip.check_id = pn_check_id
105: AND aip.invoice_id = aid.invoice_id

Line 130: xla_distribution_links xdln ,

126: MIN(aip.invoice_id) invoice_id
127: FROM ap_invoice_distributions aid ,
128: ap_invoice_payments aip ,
129: ap_payment_hist_dists payh ,
130: xla_distribution_links xdln ,
131: xla_ae_headers xlah
132: WHERE aip.invoice_id = pn_invoice_id
133: AND aip.check_id = pn_check_id
134: AND aip.invoice_id = aid.invoice_id

Line 158: xla_distribution_links xdln ,

154: xlah.ledger_id ,
155: SUM(xdln.unrounded_accounted_dr) pay_amount
156: FROM ap_invoice_distributions_all aid ,
157: ap_payment_hist_dists payh ,
158: xla_distribution_links xdln ,
159: xla_ae_headers xlah ,
160: ap_invoice_payments_all aip
161: WHERE aid.invoice_id = cn_invoice_id
162: AND aip.invoice_payment_id = payh.invoice_payment_id

Line 196: xla_distribution_links xdln,

192: xlah.ae_header_id ,
193: xlah.ledger_id ,
194: SUM(xdln.unrounded_accounted_dr) pay_amount
195: FROM ap_invoice_distributions_all aid ,
196: xla_distribution_links xdln,
197: xla_ae_headers xlah
198: WHERE aid.invoice_id = cn_invoice_id
199: AND aid.line_type_lookup_code = 'AWT'
200: AND xdln.event_id = aid.accounting_event_id

Line 244: xla_distribution_links xdln,

240: ELSE
241: BEGIN
242: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
243: FROM ap_invoice_distributions_all aid ,
244: xla_distribution_links xdln,
245: xla_ae_headers xlah
246: WHERE aid.invoice_id = ln_invoice_id
247: AND aid.line_type_lookup_code <> 'AWT'
248: AND xdln.event_id = aid.accounting_event_id