USP_DATALIST_PROGRAMPRICE

Lists the prices attached to a program

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PROGRAMPRICE
(
    @PROGRAMID uniqueidentifier,
    @INCLUDEINACTIVE bit = 0
) as
set nocount on;

select
    PROGRAMPRICE.ID,
    dbo.UFN_PRICETYPECODE_GETDESCRIPTION(PRICETYPECODEID) as PRICETYPE,
    FACEPRICE,
    PROGRAMPRICE.PRICETYPECODEID
from
    dbo.PROGRAMPRICE
inner join dbo.PRICETYPECODE on
    PRICETYPECODE.ID = PROGRAMPRICE.PRICETYPECODEID
where
    PROGRAMID = @PROGRAMID and
    (@INCLUDEINACTIVE = 1 or PRICETYPECODE.ACTIVE = 1)
order by
    PROGRAMPRICE.SEQUENCE;