UFN_RECOGNITIONLEVEL_GETBENEFITS
Returns all benefits for a given recognition level record.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECOGNITIONLEVELID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_RECOGNITIONLEVEL_GETBENEFITS(@RECOGNITIONLEVELID uniqueidentifier)
returns table
as
return
(
select
[ID],
[BENEFITID],
[QUANTITY],
[UNITVALUE],
QUANTITY * UNITVALUE as [TOTALVALUE],
[DETAILS],
[SEQUENCE]
from dbo.RECOGNITIONLEVELBENEFIT
where RECOGNITIONLEVELID = @RECOGNITIONLEVELID
)