DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on PO_VENDORS

Line 738: l_vendor_name po_vendors.vendor_name%TYPE;

734: l_org_id NUMBER(15);
735: l_comments VARCHAR2(240);
736: l_iteration NUMBER(9);
737: l_vendor_site_code VARCHAR2(15);
738: l_vendor_name po_vendors.vendor_name%TYPE;
739: l_description VARCHAR2(240);
740: l_currency VARCHAR2(15);
741: l_vendor_id NUMBER(15);
742: l_vendor_site_id NUMBER(15);

Line 804: FROM PO_VENDORS

800: WHERE invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
801:
802: SELECT vendor_name
803: INTO l_vendor_name
804: FROM PO_VENDORS
805: WHERE vendor_id = l_vendor_id;
806:
807: SELECT vendor_site_code
808: INTO l_vendor_site_code