SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_nm_claims_conventions]
	@convention_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM nm_claims_conventions
	WHERE @convention_code = '%' OR cnv_convention_code = @convention_code
END
GO
