USP_PROSPECTRESEARCHREQUEST_ASSIGNEDALERT_SEND

This procedure sends an email alert to the assignee of a prospect research request if the assignee is not the current application user.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN
@PROSPECTRESEARCHREQUESTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_PROSPECTRESEARCHREQUEST_ASSIGNEDALERT_SEND (
                @CURRENTAPPUSERID uniqueidentifier,
                @PROSPECTRESEARCHREQUESTID uniqueidentifier
            )as begin
            set nocount on;

                declare
                    @ASSIGNEDTOAPPUSERID uniqueidentifier;

                select
                    @ASSIGNEDTOAPPUSERID = ASSIGNEDTOAU.[ID]
                from
                    dbo.[PROSPECTRESEARCHREQUEST] PRR
                left join
                    dbo.[APPUSER] ASSIGNEDTOAU on ASSIGNEDTOAU.[CONSTITUENTID] = PRR.[ASSIGNEDTOID]
                where
                    PRR.[ID] = @PROSPECTRESEARCHREQUESTID;

                if @ASSIGNEDTOAPPUSERID is not null and @ASSIGNEDTOAPPUSERID <> @CURRENTAPPUSERID begin
                    exec dbo.USP_ALERTTYPE_SENDTOAPPUSER 'FB091E4E-B596-445c-B5E5-4E32ED9ACE08', @ASSIGNEDTOAPPUSERID, @PROSPECTRESEARCHREQUESTID;
                end

                return 0;
            end