USP_SIMPLEDATALIST_PROGRAMPRICE

Returns a list of program prices for all applicable price types.

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_PROGRAMPRICE
            (@PROGRAMID uniqueidentifier = null)
            as
            select 
                PRICETYPECODEID as VALUE, 
                FACEPRICE as LABEL
            from dbo.PROGRAMPRICE
            where PROGRAMID = @PROGRAMID
            order by SEQUENCE