USP_PROSPECTRESEARCHREQUEST_UNASSIGNEDPENDINGALERT_SEND

            create procedure dbo.USP_PROSPECTRESEARCHREQUEST_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] = '2DBE413F-4623-4708-B7B4-8C223AF27B19' 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 '2DBE413F-4623-4708-B7B4-8C223AF27B19', @APPUSERID, @PROSPECTRESEARCHREQUESTID;

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

                return 0;
            end