USP_DATALIST_FEEPROGRAM

Lists the programs associated with a fee.

Parameters

Parameter	Parameter Type	Mode	Description
@FEEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_FEEPROGRAM
                (
                    @FEEID uniqueidentifier
                )
                as
                set nocount on;
                select 
                    PROGRAM.ID,
                    PROGRAMFEE.ID AS PROGRAMFEEID,
                    PROGRAM.NAME,
                    PROGRAM.ISACTIVE,
                    PROGRAM.DESCRIPTION
                from dbo.PROGRAM
                inner join dbo.PROGRAMFEE on PROGRAM.ID=PROGRAMFEE.PROGRAMID 
                    where PROGRAMFEE.FEEID= @FEEID
                order by NAME;