PROCEDURE get_user_company_cif(
    prm_id_in      IN NUMBER
    ,own_cif_out   OUT NUMBER)
  IS
  BEGIN

  SELECT vbt_owners.own_cif
  INTO own_cif_out
  FROM hdt_permits
  JOIN vibank.vbt_owners ON (prm_own_id = own_id AND prm_id = prm_id_in);

  END;

-- next err code = 01001125