USP_DATALIST_APPEALLOOKUP

Provides look-up information for an appeal for a given amount.

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALID	uniqueidentifier	IN	Appeal ID
@AMOUNT	money	IN	Amount

Definition

Copy



                create procedure dbo.USP_DATALIST_APPEALLOOKUP
                (
                    @APPEALID uniqueidentifier,
                    @AMOUNT money
                )
                as
                set nocount on;

                select 
                    BENEFITID,
                    dbo.UFN_BENEFIT_GETNAME(BENEFITID) as [TRANSLATION],
                    VALUE,
                    QUANTITY,
                    SEQUENCE
                from dbo.UFN_APPEAL_GETBENEFITDETAILS(@APPEALID, @AMOUNT)