80: WHERE unit_of_measure = pv_unit_of_measure;
81:
82: CURSOR c_vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
83: SELECT vendor_id 84: FROM po_vendors 85: WHERE vendor_name = p_sugg_vendor_name;
86:
87: CURSOR c_vend_site_cur(p_sugg_vendor_loc IN VARCHAR2, p_vendor_id IN NUMBER, p_org_id IN NUMBER) IS
88: SELECT Vendor_Site_Id