SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_pr_families_natures]
	@family_code ais_code_short,
	@nature_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM	pr_families_natures a
	WHERE	a.pfn_family_code = @family_code
	and		(
			@nature_code = '%' 
			OR 
			pfn_nature_code = @nature_code
			)
END

GO
