DROP PROCEDURE IF EXISTS uspGetAktivCsengetesiRendId
GO
  CREATE PROCEDURE uspGetAktivCsengetesiRendId
    @pTanevId INT
   ,@pIntezmenyId INT
  AS
  BEGIN
    SET NOCOUNT ON;

    SELECT ID AS Id
    FROM T_CSENGETESIREND_OSSZES
    WHERE C_AKTIV = 'T'
      AND C_TANEVID = @pTanevId
      AND C_INTEZMENYID = @pIntezmenyId
      AND TOROLT = 'F'
  END
GO