USP_RESEARCHGROUPREPORT_PROSPECTWEALTHCAPACITY

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_RESEARCHGROUPREPORT_PROSPECTWEALTHCAPACITY
          (
                        @CONSTITUENTID uniqueidentifier = null,
            @ISVISIBLE bit = 1,
                        @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_WEALTHINFORMATIONDASHBOARDGIVINGCAPACITY @CONSTITUENTID, @ISVISIBLE, @CURRENTAPPUSERID;