USP_DATALIST_PROGRAMTAX

Lists the taxes associated with 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_PROGRAMTAX
                (
                    @PROGRAMID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                set nocount on;
                select 
                    TAX.ID,
                    PROGRAMTAX.ID AS PROGRAMTAXID,
                    NAME,
                    TOTALTAX,
                    ISACTIVE,
                    DESCRIPTION
                from dbo.TAX
                inner join dbo.PROGRAMTAX on TAX.ID=PROGRAMTAX.TAXID 
                where 
                    PROGRAMTAX.PROGRAMID=@PROGRAMID and
                    (@INCLUDEINACTIVE = 1 or TAX.ISACTIVE = 1)
                order by NAME;