USP_DATALIST_PROSPECTRESEARCHREPORTPHONENUMBERS

CREATE procedure dbo.USP_DATALIST_PROSPECTRESEARCHREPORTPHONENUMBERS(
@CONSTITUENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier=null
)
as

    set nocount on;
                    declare @ISADMIN bit;
                    declare @APPUSER_IN_NONRACROLE bit;
                    declare @APPUSER_IN_NOSECGROUPROLE bit;

                    set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

    select P.ID,
           dbo.UFN_PHONE_GETINTERNATIONALNUMBER(P.COUNTRYID, P.NUMBER) as NUMBER,
           P.ISPRIMARY,
           P.SEQUENCE,
       P.DONOTCALL,
       PTC.DESCRIPTION,
       P.STARTDATE,
       P.ENDDATE,
       P.ISCONFIDENTIAL

    from dbo.PHONE P
  left outer join dbo.PHONETYPECODE PTC ON P.PHONETYPECODEID = PTC.ID

    where P.CONSTITUENTID = @CONSTITUENTID
    and (@ISADMIN = 1 or 
                                @APPUSER_IN_NONRACROLE = 1 or
                                dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, P.CONSTITUENTID, @APPUSER_IN_NOSECGROUPROLE) = 1)
  order by SEQUENCE;