USP_DATALIST_PAYMENTACCOUNTSBYCONSTITUENT

            CREATE procedure dbo.USP_DATALIST_PAYMENTACCOUNTSBYCONSTITUENT(@CONSTITUENTID uniqueidentifier = null)
            as

            set nocount on;

            begin try

                -- Open the symmetric key for decryption

                exec dbo.USP_GET_KEY_ACCESS;

                    select CONSTITUENTACCOUNT.ID,
                    dbo.UFN_CONSTITUENTACCOUNT_GETACCOUNTNUMBERINWEBFORMAT(FINANCIALINSTITUTION.FINANCIALINSTITUTION, coalesce(convert(nvarchar(50), DecryptByKey(CONSTITUENTACCOUNT.ACCOUNTNUMBER)),''), CONSTITUENTACCOUNT.ACCOUNTTYPE) as ACCOUNTDESCRIPTION,
                    0 as PAYMENTACCOUNTTYPE
                    from dbo.CONSTITUENTACCOUNT
                    inner join
                        dbo.FINANCIALINSTITUTION
                    on
                        CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID = FINANCIALINSTITUTION.ID
                    where
                        CONSTITUENTID = @CONSTITUENTID

                    union all

                    select distinct cc.CREDITCARDTOKEN, 
                    dbo.UFN_CONSTITUENTCREDITCARD_GETCARDINFOINWEBFORMAT(cc.CREDITCARDPARTIALNUMBER, cc.EXPIRESON, cc.CREDITTYPECODEID, cc.CARDHOLDERNAME)as ACCOUNTDESCRIPTION,
                    1 as PAYMENTACCOUNTTYPE
                    from dbo.REVENUE r
                    inner join dbo.REVENUESCHEDULE rs on rs.ID = r.ID 
                    inner join dbo.CREDITCARD cc on cc.ID = rs.CREDITCARDID 
                    where
                        r.CONSTITUENTID = @CONSTITUENTID 

                close symmetric key sym_BBInfinity;
            end try

            begin catch
                close symmetric key sym_BBInfinity;
            end catch