USP_SIMPLEDATALIST_REVENUELIFECYCLES

Lists all of the available lifecycle types based on lifecycle group id.

Parameters

Parameter	Parameter Type	Mode	Description
@LIFECYCLEGROUPCODE	int	IN	LIFECYCLEGROUPCODE

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_REVENUELIFECYCLES 
(
    @LIFECYCLEGROUPCODE int
)
as
    set nocount on;

    select 
        ID as VALUE, 
        NAME as LABEL
    from 
        dbo.LIFECYCLETYPE
    where
        LIFECYCLEGROUPCODE = @LIFECYCLEGROUPCODE and
        dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(INSTALLEDPRODUCTLIST) = 1
    order by 
        NAME