--------------------------------------------------------------------------------------------
--- DEFINICJA PROCEDURY SKLADOWANEJ
--- Name : PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer
--- Created by : sbialy
--------------------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer]
GO
PRINT 'Creating procedure PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer';
GO

SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer]
    @INFAccountId BIGINT
AS
BEGIN
    BEGIN TRY
        SELECT vc.Id as Value
            , vc.Name
        FROM dbo.INFVoucherConfig vc WITH(NOLOCK)
        WHERE vc.INFAccountId = @INFAccountId
            AND vc.Type = 4 /*Loyalty offer - iSeeWallet*/
            AND vc.IsActive = 1

    END TRY
    BEGIN CATCH
        THROW; --kture niepotrzebne?
        BLADWYKONANIA: --czy to? i co to?
        RETURN(99);
    END CATCH

    --------------------------------------------------------------------------
    -- zakonczenie procedury
    RETURN(0);

END
GO
--- koniec PV_INFWEBGetVoucherConfigByINFAccountIdAndTypeOffer