USP_DATALIST_ORGANIZATIONVSECONSTITUENCIES

                CREATE procedure dbo.USP_DATALIST_ORGANIZATIONVSECONSTITUENCIES
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select
                        ID,
                        VSECONSTITUENCY,
                        dbo.UFN_VSECONSTITUENCY_CONSTITUENCYLIST2(ID, @INCLUDEINACTIVE) as CONSTITUENCY,
                        SEQUENCE,
                        case when (select top 1 1 from dbo.VSECONSTITUENCYMAP where VSECONSTITUENCYMAP.VSECONSTITUENCYID = VSECONSTITUENCY.ID) = 1 then
                            ''
                        else
                            'RES:warning'
                        end
                    from 
                        dbo.VSECONSTITUENCY 
                    where
                        TYPECODE = 1 and (USAGETYPECODE = (select vsetypecode from dbo.vsetype) or USAGETYPECODE = 2)
                    order by SEQUENCE