USP_SIMPLEDATALIST_DISCOUNTAVAILABILITYCONSTITUENCY

Gets a list of all active constituent codes for discount availability.

Definition



                create procedure dbo.USP_SIMPLEDATALIST_DISCOUNTAVAILABILITYCONSTITUENCY
                as
                    set nocount on;

                    select 
                        ID as VALUE,
                        DESCRIPTION as LABEL
                    from dbo.CONSTITUENCYCODE
                    where ACTIVE = 1

                return 0;