USP_FENXTGETKEYINFO

            create procedure dbo.USP_FENXTGETKEYINFO
            (
                @PDACCOUNTSYSTEMID uniqueidentifier
            )
            as
                exec dbo.USP_GET_KEY_ACCESS;

                select 
                    coalesce(convert(nvarchar(2048), DecryptByKey(FENXTTOKEN.ACCESSTOKEN)),''),
                    coalesce(convert(nvarchar(256), DecryptByKey(FENXTTOKEN.REFRESHTOKEN)),''),
                    isnull(FENXTTOKEN.EXPIRESON,'17530101'),
                    FENXTINTEGRATION.ENVIRONMENTID 
                from dbo.FENXTINTEGRATION
                    inner join dbo.FENXTTOKEN on FENXTINTEGRATION.ENVIRONMENTID = FENXTTOKEN.ENVIRONMENTID 
                where FENXTINTEGRATION.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID;

                close symmetric key sym_BBInfinity;