spGetBackOfficeSystemPeople_NotificationSubscriptions

CREATE PROCEDURE [dbo].[spGetBackOfficeSystemPeople_NotificationSubscriptions]
    (
    @BackOfficeSystemPeopleID int
    )
    AS

    SELECT
    ID,
    UserID,
    NotificationID,
    ContextID,
    [Status],
    BackOfficeSystemPeopleID,
    BackOfficeSystemsID
    FROM NotificationSubscription
    WHERE 
    BackOfficeSystemPeopleID = @BackOfficeSystemPeopleID

    RETURN