ALTER PROCEDURE [dbo].[ASS_TYPE_Lis] AS BEGIN SELECT * FROM ASS_TYPE WHERE AUTH_STATUS = 'A' End