USP_SIMPLEDATALIST_BILLINGINDIVIDUALBILLINGCYCLE

Returns a list of all the billing cycle applicable to the given billing individual.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_BILLINGINDIVIDUALBILLINGCYCLE
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    select ACADEMICYEARID as VALUE,
                            NAME as LABEL,
                            NAME as DESCRIPTION
                    from dbo.UFN_GETBILLINGCYCLESBYINDIVIDUAL(@CONSTITUENTID)
                    order by DESCRIPTION;