USP_GPC_STATUS_BY_CONSTITUENTID

Parameters

Parameter	Parameter Type	Mode	Description
@UserID	int	IN
@GPCCodeID	uniqueidentifier	IN

Definition

Copy







CREATE procedure dbo.USP_GPC_STATUS_BY_CONSTITUENTID  
(  
  @UserID Int,
  @GPCCodeID uniqueidentifier
)  
as  
  declare @ISGPCEnabled as bit =0
  if exists(
              select   top 1 1  from [dbo].[CONSTITUENTSOLICITCODE] CSC  
              inner join [dbo].[SOLICITCODE] SC  on CSC.SOLICITCODEID = SC.ID  
              inner join NETCOMMUNITYCLIENTUSER as NCU on NCU.CONSTITUENTID = CSC.CONSTITUENTID and NCU.BBNCUSERID = @UserID
              where ENDDATE is null  and SC.ID = @GPCCodeid)
    begin 
      set @ISGPCEnabled = 1;
    end

    select @ISGPCEnabled