USP_CONSTITUENCYREFRESHPROCESS_GETIMPLEMENTEDUSERDEFINEDCONSTITUENCIES

create procedure dbo.USP_CONSTITUENCYREFRESHPROCESS_GETIMPLEMENTEDUSERDEFINEDCONSTITUENCIES
as
begin
    select
        CONSTITUENCYDEFINITION.ID,
        CONSTITUENCYDEFINITION.IMPLEMENTATIONTYPECODE,
        CONSTITUENCYDEFINITION.REFRESHPROCEDURE,
        CONSTITUENCYDEFINITION.ASSEMBLYNAME,
        CONSTITUENCYDEFINITION.CLASSNAME
    from
        dbo.CONSTITUENCYDEFINITION
    where
        CONSTITUENCYDEFINITION.ISSYSTEM = 0
        and CONSTITUENCYDEFINITION.IMPLEMENTATIONTYPECODE <> 0
end