318: BEGIN
319: SELECT NVL(sum(NVL(xdl.unrounded_ENTERED_dR,0)-NVL(xdl.unrounded_entered_cr,0)),0)
320: INTO ln_inv_amt_ent
321: FROM ap_invoices ai
322: ,ap_invoice_distributions aid
323: ,ap_invoice_distributions aidinv
324: ,ap_invoices aiinv
325: ,xla_events xe
326: ,xla_ae_lines xal
319: SELECT NVL(sum(NVL(xdl.unrounded_ENTERED_dR,0)-NVL(xdl.unrounded_entered_cr,0)),0)
320: INTO ln_inv_amt_ent
321: FROM ap_invoices ai
322: ,ap_invoice_distributions aid
323: ,ap_invoice_distributions aidinv
324: ,ap_invoices aiinv
325: ,xla_events xe
326: ,xla_ae_lines xal
327: ,xla_distribution_links xdl