DROP PROCEDURE IF EXISTS [dbo].[sp_GetNebuloErtesitoStatusz]
GO

CREATE PROCEDURE [dbo].[sp_GetNebuloErtesitoStatusz]
   @intezmenyId  INT
  ,@tanevId    INT
  ,@statusz    INT
AS  
BEGIN

  SET NOCOUNT ON;

  SELECT 
    ID        NebuloId
  FROM 
    T_NEBULO_OSSZES
  WHERE 
      TOROLT = 'F'
    AND C_TANEVID = @tanevId
    AND C_INTEZMENYID = @intezmenyId
    AND C_FELVETELSTATUSZA = @statusz 

END

GO