UFN_CONSTITUENCYDEFINITION_GETALLACTIVECONSTITUENCIES

create function dbo.UFN_CONSTITUENCYDEFINITION_GETALLACTIVECONSTITUENCIES()
returns table
as
return
(
    select
        ID,
        IMPLEMENTATIONTYPECODE,
        REFRESHPROCEDURE,
        ASSEMBLYNAME,
        CLASSNAME
    from
        dbo.CONSTITUENCYDEFINITION
    where
        ISACTIVE = 1
)