USP_RESEARCHGROUPREPORT_PROSPECTPHONENUMBERS

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@REPORTUSERID	nvarchar(128)	IN
@ALTREPORTUSERID	nvarchar(128)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_RESEARCHGROUPREPORT_PROSPECTPHONENUMBERS
(
                        @CONSTITUENTID uniqueidentifier = null,
                        @REPORTUSERID nvarchar(128) = null,
                        @ALTREPORTUSERID nvarchar(128) = null,
            @CURRENTAPPUSERID uniqueidentifier = null
                    )
          as
                    set NOCOUNT on;

          if @CURRENTAPPUSERID is null
                      set @CURRENTAPPUSERID = dbo.UFN_APPUSER_GETREPORTAPPUSERID(@REPORTUSERID, @ALTREPORTUSERID);

          exec dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDPHONENUMBERS @CONSTITUENTID, @CURRENTAPPUSERID;