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