DROP PROCEDURE IF EXISTS sp_alm_GuiaRemisionFilePDF_consult;

DELIMITER $$
CREATE  PROCEDURE `sp_alm_GuiaRemisionFilePDF_consult`(IN `id_GR` INT)
    NO SQL
BEGIN

SELECT file_name FROM `tec_referral_guide_files` WHERE referral_guide_id = id_GR;

END$$
DELIMITER ;