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

	SELECT	*
	FROM nm_pol_renew_types
	WHERE @renew_type_code = '%' OR nmprt_renew_type_code = @renew_type_code
END
GO
