USP_SIMPLEDATALIST_BENEFIT_LIABILITY_REVENUE

create procedure dbo.USP_SIMPLEDATALIST_BENEFIT_LIABILITY_REVENUE (@REVENUEID uniqueidentifier = null) 
            as
                begin

                select REVENUEBENEFIT.ID as VALUE, BENEFIT.NAME as LABEL 
                from REVENUEBENEFIT 
                join BENEFIT on REVENUEBENEFIT.BENEFITID = BENEFIT.ID
                where REVENUEBENEFIT.REVENUEID  = @REVENUEID
                and REVENUEBENEFIT.ID in 
                (select REVENUEBENEFITID from BENEFITGLDISTRIBUTION 
                where  BENEFITGLDISTRIBUTION.BENEFITTYPECODE != 1
                and BENEFITGLDISTRIBUTION.REVENUEID = @REVENUEID);

                end