SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_claim_smvts]
	@mvt_code AS ais_code_short,
	@smvt_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM	claim_smvts
	WHERE	csmvt_mvt_code = @mvt_code
	and		(@smvt_code = '%' or csmvt_smvt_code like @smvt_code)
END

GO
