USP_SIMPLELIST_CONSTITUENCYALL

                CREATE procedure dbo.USP_SIMPLELIST_CONSTITUENCYALL
                as
                begin
                    set nocount on;

                    select 
                        ID [VALUE],
                        DESCRIPTION [LABEL]
                    from 
                        dbo.V_CONSTITUENCYDISPLAYORDER
                    where
                        ISACTIVE = 1
                    order by 
                        DESCRIPTION

                    return 0;
                end