APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 433: from ap_invoice_distributions aid

429:
430: -- BUG 4121323 : selecting base_amount
431: select sum(nvl(aid.base_amount,aid.amount))
432: into l_prev_withheld_amt
433: from ap_invoice_distributions aid
434: where aid.invoice_id=rec_new_payments.invoice_id
435: and aid.awt_invoice_payment_id
436: in (select invoice_payment_id
437: from ap_invoice_payments aip

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:

Line 484: AP_INVOICE_DISTRIBUTIONS AID

480: /* Bug 3309344 commenting this select statement
481: SELECT MAX(AID.awt_gross_amount)
482: INTO l_awt_gross_amount
483: FROM AP_INVOICE_PAYMENTS AIP,
484: AP_INVOICE_DISTRIBUTIONS AID
485: WHERE AIP.invoice_id = rec_new_payments.invoice_id
486: AND AIP.check_id = p_old_check_id
487: AND AIP.reversal_inv_pmt_id IS NULL
488: AND AID.awt_invoice_payment_id = AIP.invoice_payment_id;

Line 757: FROM ap_invoice_distributions AID

753: INTO l_call_withholding
754: FROM ap_invoices AI
755: WHERE AI.invoice_id = p_invoice_id
756: AND EXISTS ( SELECT 'At least 1 AWT line created automatically at payment time'
757: FROM ap_invoice_distributions AID
758: WHERE aid.invoice_id = ai.invoice_id
759: AND aid.awt_invoice_payment_id is not null);
760:
761: RETURN(TRUE);