fnGetRaisersEdgeRecordIDFromEmailJobRecipientID

CREATE FUNCTION [dbo].[fnGetRaisersEdgeRecordIDFromEmailJobRecipientID]
    (
    @EmailJobRecipientID int
    )
RETURNS int
AS
BEGIN
    DECLARE @RaisersEdgeRecordID int
    SELECT @RaisersEdgeRecordID = dbo.fnGetRaisersEdgeRecordIDFromPeopleID(er.BackofficeSystemPeopleID)
        FROM [dbo].EmailJob_Recipient er
        WHERE ID = @EmailJobRecipientID
    IF @@ROWCOUNT = 0
        SET @RaisersEdgeRecordID = 0
        RETURN @RaisersEdgeRecordID
    END