SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[p_grid_md_types_cpl]
    @type_name ais_name = '%'
AS 
    BEGIN
        SELECT  typ_type_name ,
                typ_l1 ,
                typ_l2 ,
                typ_l3
        FROM    dbo.md_types
        WHERE   ( @type_name = '%'
                  OR typ_type_name = @type_name
                )
                AND typ_is_dyn != 0
    END


GO
