drop procedure if exists sp_alm_motivoguiaremision_list;
DELIMITER $$
CREATE  PROCEDURE `sp_alm_motivoguiaremision_list`()
    NO SQL
BEGIN

SELECT code, description FROM tec_motive_referral_guide;

END$$
DELIMITER ;