DBA Data[Home] [Help]

APPS.AP_AUTO_PAYMENT_PKG dependencies on AP_INVOICES

Line 665: FROM ap_invoices AI

661: BEGIN
662:
663: SELECT 'Y'
664: INTO l_call_withholding
665: FROM ap_invoices AI
666: WHERE AI.invoice_id = p_invoice_id
667: AND EXISTS ( SELECT 'At least 1 AWT line created automatically at payment time'
668: FROM ap_invoice_distributions AID
669: WHERE aid.invoice_id = ai.invoice_id