fnGetNotificationIDByTypeAndWorkflowID

                  CREATE FUNCTION [dbo].[fnGetNotificationIDByTypeAndWorkflowID]
                  (
                  @NotificationTypeID int,
                  @WorkflowID int
                  )
                  RETURNS int
                  AS

                  BEGIN
                  RETURN
                  (SELECT n.ID
                  FROM dbo.NC_Notification n
                  INNER JOIN dbo.Notification_Workflow nw ON nw.NotificationID = n.ID AND nw.WorkflowID = @WorkflowID
                  WHERE
                  n.NotificationTypeID = @NotificationTypeID AND n.Enabled = 1)
                  END