451:
452: select
453: sum(nvl(aid.base_amount,aid.amount))
454: into l_invoice_amount
455: from ap_invoice_distributions_all aid
456: where invoice_id = rec_new_payments.invoice_id
457: and line_type_lookup_code not in ('AWT');
458:
459: select sum(nvl(aid.base_amount,aid.amount))
457: and line_type_lookup_code not in ('AWT');
458:
459: select sum(nvl(aid.base_amount,aid.amount))
460: into l_validation_awt_amount
461: from ap_invoice_distributions_all aid
462: where invoice_id = rec_new_payments.invoice_id
463: and line_type_lookup_code = 'AWT'
464: and awt_invoice_payment_id is null;
465: