UFN_MEMBERSHIPDUESBATCH_GETBENEFITS

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETBENEFITS
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return (
    select
        ID,
        BENEFITID,
        QUANTITY,
        UNITVALUE,
        DETAILS,
        SEQUENCE
    from dbo.BATCHMEMBERSHIPDUESBENEFIT
    where BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
)