
ALTER PROCEDURE [dbo].[reg_gen_envioCorreo]
	@p_id INT
AS
BEGIN
	SELECT 	[id] AS [id],
		[uid] AS [uid],
		[eid] AS [eid],
		[id_usuario_modifico] AS [id_usuario_modifico],
		[id_usuario_creo] AS [id_usuario_creo],
		[fechaModificacion] AS [fechaModificacion],
		[fechaCreacion] AS [fechaCreacion],
		[active] AS [active],
		[envioCorreo] AS [envioCorreo],
		[envioCorreo_codigo] AS [envioCorreo_codigo],
		[estrategia] AS [estrategia],
		[tabla] AS [tabla],
		[id_reporte] AS [id_reporte],
		[correoAdicional] AS [correoAdicional],
		[plantillaAdjunto] AS [plantillaAdjunto],
		[id_subtipoDocumento] AS [id_subtipoDocumento],
		[id_estadoTipoDocumento] AS [id_estadoTipoDocumento],
		[cantidadMensajes] AS [cantidadMensajes],
		[tiempo_por_mensajes] AS [tiempo_por_mensajes],
		[cantidadReintento] AS [cantidadReintento],
		[adjuntarArchivo] AS [adjuntarArchivo]
	FROM [gen_envioCorreo]
	WHERE	(id = @p_id)

END


