USP_PROSPECTRESEARCHREQUESTCONSTITUENT_UNASSIGNEDPENDINGALERT_SEND

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

                declare @APPUSERID uniqueidentifier;
                declare APPUSERSCURSOR cursor local fast_forward for
                select
                    ATS.[APPUSERID]
                from
                    dbo.APPUSERALERTTYPESETTING ATS
                where
                    ATS.[ALERTTYPEID] = '158D6701-217D-4751-9682-E9926E8616E6' and
                    ATS.[ENABLED] = 1;

                open APPUSERSCURSOR;
                fetch next from APPUSERSCURSOR into @APPUSERID;
                while @@FETCH_STATUS = 0 begin
                    if @APPUSERID <> @CURRENTAPPUSERID
                        exec dbo.USP_ALERTTYPE_SENDTOAPPUSER '158D6701-217D-4751-9682-E9926E8616E6', @APPUSERID, @PROSPECTRESEARCHREQUESTID;

                    fetch next from APPUSERSCURSOR into @APPUSERID;
                end
                close APPUSERSCURSOR;
                deallocate APPUSERSCURSOR;

                return 0;
            end