40: WHERE unit_of_measure = pv_unit_of_measure;
41:
42: CURSOR c_vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
43: SELECT vendor_id 44: FROM po_vendors 45: WHERE vendor_name = p_sugg_vendor_name;
46:
47: CURSOR c_vend_site_cur(p_sugg_vendor_loc IN VARCHAR2, p_vendor_id IN NUMBER, p_org_id IN NUMBER) IS
48: SELECT Vendor_Site_Id