USP_PROSPECTASSIGNMENTPROCESS_GETPARAMETERS

            CREATE procedure dbo.USP_PROSPECTASSIGNMENTPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier
            )
            as
            begin
                set nocount on;

                select
                    PROSPECTASSIGNMENTPROCESS.NAME,
                    PROSPECTASSIGNMENTPROCESS.PROCESSTYPECODE,
                    PROSPECTASSIGNMENTPROCESS.PROSPECTSELECTIONID,
                    PROSPECTASSIGNMENTPROCESS.SOURCEMANAGERID,
                    PROSPECTASSIGNMENTPROCESS.DESTINATIONMANAGERID,
                    PROSPECTASSIGNMENTPROCESS.INCLUDEPROSPECTMANAGERS,
                    PROSPECTASSIGNMENTPROCESS.INCLUDEPRIMARYMANAGERS,
                    PROSPECTASSIGNMENTPROCESS.INCLUDESECONDARYMANAGERS,
                    PROSPECTASSIGNMENTPROCESS.INCLUDESECONDARYSOLICITORS,
                    PROSPECTASSIGNMENTPROCESS.INCLUDESTEPSANDINTERACTIONS,

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

                    IDSETREGISTER.NAME as PROSPECTSELECTIONNAME,
                    SOURCEMANAGER.NAME as SOURCEMANAGERNAME,
                    DESTINATIONMANAGER.NAME as DESTINATIONMANAGERNAME
                from dbo.PROSPECTASSIGNMENTPROCESS
                left join dbo.IDSETREGISTER on PROSPECTASSIGNMENTPROCESS.PROSPECTSELECTIONID = IDSETREGISTER.ID
                left join dbo.CONSTITUENT as SOURCEMANAGER on PROSPECTASSIGNMENTPROCESS.SOURCEMANAGERID = SOURCEMANAGER.ID
                left join dbo.CONSTITUENT as DESTINATIONMANAGER on PROSPECTASSIGNMENTPROCESS.DESTINATIONMANAGERID = DESTINATIONMANAGER.ID
                where PROSPECTASSIGNMENTPROCESS.ID = @ID;                
            end