UFN_CONSTITUENCYREFRESHPROCESS_GETCONSTITUENCIES

CREATE function dbo.UFN_CONSTITUENCYREFRESHPROCESS_GETCONSTITUENCIES
(
    @CONSTITUENCYREFRESHPROCESSID uniqueidentifier
)
returns table
as
return
(
    select 
        CONSTITUENCYREFRESHPROCESSCONSTITUENCY.ID, 
        CONSTITUENCYREFRESHPROCESSCONSTITUENCY.CONSTITUENCYDEFINITIONID,
        CONSTITUENCYDEFINITION.ISSYSTEM,
        CONSTITUENCYDEFINITION.IMPLEMENTATIONTYPECODE,
        CONSTITUENCYDEFINITION.REFRESHPROCEDURE,
        CONSTITUENCYDEFINITION.ASSEMBLYNAME,
        CONSTITUENCYDEFINITION.CLASSNAME
    from 
        dbo.CONSTITUENCYREFRESHPROCESSCONSTITUENCY
        inner join dbo.CONSTITUENCYDEFINITION
            on CONSTITUENCYDEFINITION.ID = CONSTITUENCYREFRESHPROCESSCONSTITUENCY.CONSTITUENCYDEFINITIONID
    where 
        CONSTITUENCYREFRESHPROCESSCONSTITUENCY.CONSTITUENCYREFRESHPROCESSID = @CONSTITUENCYREFRESHPROCESSID
)