USP_REVENUE_GETTRIBUTESBASICDETAILS

      CREATE procedure [dbo].[USP_REVENUE_GETTRIBUTESBASICDETAILS] 
                (
                    @REVENUEID uniqueidentifier
                )
                as 
                begin
        select 
            RT.ID as REVENUETRIBUTEID,
            RT.TRIBUTEID as TRIBUTEID,
            T.TRIBUTEEID,
            T.TRIBUTETEXT,
            TTC.[DESCRIPTION] as [TYPE],
            C.NAME as TRIBUTEENAME,
            C.FIRSTNAME as TRIBUTEEFIRST,
            C.KEYNAME as TRIBUTEELAST
        from 
            dbo.REVENUETRIBUTE RT
            inner join dbo.TRIBUTE T
                ON RT.TRIBUTEID = T.ID
            inner join dbo.TRIBUTETYPECODE TTC
                ON TTC.ID = T.TRIBUTETYPECODEID
            inner join dbo.CONSTITUENT C
                ON C.ID = T.TRIBUTEEID
        where 
            RT.REVENUEID = @REVENUEID
            and
            T.ISACTIVE = 1
        end