UFN_BENEFIT_GETBENEFITOPTIONS
Get benefit options of a given benefit record
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BENEFITID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BENEFIT_GETBENEFITOPTIONS(@BENEFITID uniqueidentifier)
returns table
as
return
(
SELECT
eb.[ID],
eb.[BENEFITOPTIONID],
b.NAME,
b.[DESCRIPTION] AS DETAILS
FROM dbo.BenefitBenefitOption eb (NOLOCK)
INNER JOIN dbo.BENEFITOPTION b (NOLOCK) ON eb.BENEFITOPTIONID = b.ID
WHERE eb.BENEFITID = @BENEFITID
)