SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[p_grid_dyn_scenarios_claim_act]
    @scen_code ais_code_short = '%'
AS 
    BEGIN
        SELECT  sc_scen_code ,
                sc_l1 ,
                sc_l2 ,
                sc_l3
        FROM    dbo.dyn_scenarios
        WHERE   ( @scen_code = '%'
                  OR sc_scen_code = @scen_code)
                AND sc_type_code = 'sa'
    END
GO
