
ALTER PROCEDURE [dbo].[reg_cnt_contratoDetalleVisita]
	@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],
		[contratoDetalleVisita] AS [contratoDetalleVisita],
		[contratoDetalleVisita_codigo] AS [contratoDetalleVisita_codigo],
		[frecuencia] AS [frecuencia],
		[cadaN] AS [cadaN],
		[dia] AS [dia],
		[estrategia] AS [estrategia],
		[porTrabajo] AS [porTrabajo],
		[incluirMenores] AS [incluirMenores],
		[aproximarA] AS [aproximarA],
		[fecha_ff] AS [fecha_ff],
		[id_contrato] AS [id_contrato],
		[diaHabil] AS [diaHabil],
		[fechaInactivaInicial_ff] AS[fechaInactivaInicial_ff],
		[fechaInactivaFinal_ff] AS[fechaInactivaFinal_ff]
	FROM [cnt_contratoDetalleVisita]
	WHERE	(id = @p_id)

END