SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[p_grid_nm_claims_natures]
	@convention_code AS ais_code_short,  
	@nature_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM	nm_claims_natures
	WHERE	nat_convention_code = @convention_code
	AND		(@nature_code = '%' OR nat_nature_code = @nature_code)
END
GO
