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

    SELECT ID
    FROM T_ADATSZOLGALTATASENAPLO_OSSZES
    WHERE TOROLT = 'F'
      AND C_INTEZMENYID = @pIntezmenyId
      AND C_TANEVID = @pTanevId
  END
GO