USP_RECORDOPERATION_DELETEGROUPMEMBERSTEP

Provides the prompt for the "Group Member Stewardship Plan Step Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@OWNERNAME	nvarchar(154)	INOUT

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_DELETEGROUPMEMBERSTEP
(
    @ID uniqueidentifier,
    @OWNERNAME nvarchar(154) output
)
as 
    set nocount on;

    select
        @OWNERNAME = NF.NAME
    from dbo.STEWARDSHIPPLANSTEP STEP
    inner join dbo.STEWARDSHIPPLAN [PLAN]
      on STEP.PLANID = [PLAN].ID    
    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME([PLAN].CONSTITUENTID) NF
    where STEP.ID = @ID