USP_DATALIST_REGISTRANTBENEFIT

Displays the benefits for a given registrant.

Parameters

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

Definition

Copy



                    create procedure dbo.USP_DATALIST_REGISTRANTBENEFIT(
                        @REGISTRANTID uniqueidentifier
                    )
                    as
                    set nocount on;

                    select
                        ID,
                        NAME = dbo.UFN_BENEFIT_GETNAME (BENEFITID),
                        QUANTITY,
                        UNITVALUE,
                        TOTALVALUE,
                        DETAILS
                    from
                        dbo.REGISTRANTBENEFIT
                    where
                        REGISTRANTID = @REGISTRANTID
                    order by
                        [NAME];