UFN_PROGRAMFEE_VALIDFEE

        create function dbo.UFN_PROGRAMFEE_VALIDFEE
        (
            @ID uniqueidentifier
        )
        returns bit
        with execute as caller
        as begin
            return (
                select
                    case
                        when APPLIESTOCODE = 0 then 0
                        else 1
                    end
                from dbo.PROGRAMFEE
                inner join dbo.FEE on
                    FEE.ID = PROGRAMFEE.FEEID
                where PROGRAMFEE.ID = @ID
            )
        end