spLoadRecord_Notification

    CREATE PROCEDURE [dbo].[spLoadRecord_Notification]
                  (
                  @PKID int
                  )
                  AS

                  SELECT
                  ID,
                  NotificationTypeID,
                  DisplayName,
                  Description,
                  EmailTemplateID,
                  Enabled
                  FROM NC_Notification
                  WHERE ID = @PKID

                  SELECT SiteContentID 
                  FROM Notification_SiteContent
                  WHERE NotificationID = @PKID

                  SELECT WorkflowID 
                  FROM Notification_Workflow
                  WHERE NotificationID = @PKID

                  RETURN