DBA Data[Home] [Help]

APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 455: from ap_invoice_distributions_all aid

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))

Line 461: from ap_invoice_distributions_all aid

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: