UFN_SELECTION_CONSTITUENT_NOKNOWNAFFINITY

CREATE function dbo.UFN_SELECTION_CONSTITUENT_NOKNOWNAFFINITY()
returns table
as return
(      
    select 
        CONSTITUENTID as ID
    from 
        dbo.REVENUELIFECYCLE
        inner join dbo.LIFECYCLETYPE on LIFECYCLETYPE.ID = REVENUELIFECYCLE.LIFECYCLETYPEID 
    where
        LIFECYCLETYPE.LIFECYCLEGROUPCODE = 0 and
        LIFECYCLETYPE.NAME = 'No known affinity'
)