UFN_MEMBERSHIP_WITHRENEWALWINDOW_GETNOLONGERACTIVEDATE

CREATE function dbo.UFN_MEMBERSHIP_WITHRENEWALWINDOW_GETNOLONGERACTIVEDATE
(
    @MEMBERSHIPID as uniqueidentifier,
    @ORIGINALTRANSACTIONEXPIRATIONDATE datetime
)
returns datetime
with execute as caller
as begin
    return (
        select top 1 NOLONGERACTIVEDATE
        from dbo.UFN_MEMBERSHIP_WITHRENEWALWINDOW_GETNOLONGERACTIVEDATES()
        where MEMBERSHIPID = @MEMBERSHIPID
            and EXPIRATIONDATE = @ORIGINALTRANSACTIONEXPIRATIONDATE
    )
end