USP_SIMPLEDATALIST_ALLFEE

Lists all valid fees for a program.

Definition

Copy


                CREATE procedure dbo.USP_SIMPLEDATALIST_ALLFEE as
                select 
                    ID as VALUE
                    NAME as LABEL
                from dbo.FEE
                where 
                    ISACTIVE = 1 and
                    APPLIESTOCODE = 1
                order by NAME