USP_STEWARDSHIPPLANASSIGNMENTPROCESS_GETPARAMETERS

create procedure dbo.USP_STEWARDSHIPPLANASSIGNMENTPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    set nocount on;

    select
        STEWARDSHIPPLANASSIGNMENTPROCESS.NAME,
        STEWARDSHIPPLANASSIGNMENTPROCESS.DESCRIPTION,
        STEWARDSHIPPLANASSIGNMENTPROCESS.MODECODE,
        STEWARDSHIPPLANASSIGNMENTPROCESS.OLDOFFICERID,
        STEWARDSHIPPLANASSIGNMENTPROCESS.IDSETREGISTERID,
        STEWARDSHIPPLANASSIGNMENTPROCESS.NEWOFFICERID,
        STEWARDSHIPPLANASSIGNMENTPROCESS.TRANSFERPLANMANAGERASSIGNMENTS,
        STEWARDSHIPPLANASSIGNMENTPROCESS.TRANSFERPLANSTEWARDASSIGNMENTS,
        STEWARDSHIPPLANASSIGNMENTPROCESS.TRANSFERASSIGNEDSTEPRESPONSIBILITIES,
        STEWARDSHIPPLANASSIGNMENTPROCESS.ROLECODEID,

        -- Pulling the NAME values so they can be saved for the report

        IDSETREGISTER.NAME as PLANSELECTIONNAME,
        SOURCE.NAME as OLDOFFICERNAME,
        DESTINATION.NAME as NEWOFFICERNAME
    from dbo.STEWARDSHIPPLANASSIGNMENTPROCESS
        left join dbo.IDSETREGISTER on STEWARDSHIPPLANASSIGNMENTPROCESS.IDSETREGISTERID = IDSETREGISTER.ID
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLANASSIGNMENTPROCESS.OLDOFFICERID) SOURCE
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(STEWARDSHIPPLANASSIGNMENTPROCESS.NEWOFFICERID) DESTINATION
    where STEWARDSHIPPLANASSIGNMENTPROCESS.ID = @ID;                
end