DBA Data[Home] [Help]

APPS.FV_IPAC_AUTOPAYMENTS_PKG dependencies on PO_VENDORS

Line 518: l_vendor_name Po_Vendors.vendor_name%TYPE;

514: p_invoice_num VARCHAR2,
515: x_paygroup OUT NOCOPY VARCHAR2) IS
516: l_module_name VARCHAR2(200) := g_module_name || 'Insert_IA_Txns';
517: l_vendor_id Ap_Invoices.vendor_id%TYPE;
518: l_vendor_name Po_Vendors.vendor_name%TYPE;
519: l_date Ap_Invoices.creation_date%TYPE;
520: l_count NUMBER := 0;
521: BEGIN
522: -- Check if the paygroup matches with the paygroup in Federal options.

Line 548: FROM Ap_Invoices ai, Po_Vendors pv

544:
545: BEGIN
546: SELECT ai.vendor_id, pv.vendor_name, ai.creation_date
547: INTO l_vendor_id, l_vendor_name, l_date
548: FROM Ap_Invoices ai, Po_Vendors pv
549: WHERE ai.invoice_id = p_invoice_id
550: AND ai.vendor_id = pv.vendor_id
551: AND NOT EXISTS (SELECT 'X'
552: FROM Fv_Interagency_Funds