DBA Data[Home] [Help]

APPS.FV_IPAC_AUTOPAYMENTS_PKG dependencies on PO_VENDORS

Line 506: l_vendor_name Po_Vendors.vendor_name%TYPE;

502: p_invoice_num VARCHAR2,
503: x_paygroup OUT NOCOPY VARCHAR2) IS
504: l_module_name VARCHAR2(200) := g_module_name || 'Insert_IA_Txns';
505: l_vendor_id Ap_Invoices.vendor_id%TYPE;
506: l_vendor_name Po_Vendors.vendor_name%TYPE;
507: l_date Ap_Invoices.creation_date%TYPE;
508: l_count NUMBER := 0;
509: BEGIN
510: -- Check if the paygroup matches with the paygroup in Federal options.

Line 536: FROM Ap_Invoices ai, Po_Vendors pv

532:
533: BEGIN
534: SELECT ai.vendor_id, pv.vendor_name, ai.creation_date
535: INTO l_vendor_id, l_vendor_name, l_date
536: FROM Ap_Invoices ai, Po_Vendors pv
537: WHERE ai.invoice_id = p_invoice_id
538: AND ai.vendor_id = pv.vendor_id
539: AND NOT EXISTS (SELECT 'X'
540: FROM Fv_Interagency_Funds