DROP PROCEDURE IF EXISTS sp_alm_GuiaRemisionHast_list;
DELIMITER $$
CREATE  PROCEDURE `sp_alm_GuiaRemisionHast_list`(IN `Rguia` INT)
    NO SQL
BEGIN

SELECT digest_value FROM `tec_referral_guide` WHERE id = Rguia;

END$$
DELIMITER ;