SET @notification_id = (SELECT `id` FROM `ohrm_notification` WHERE `name` = '(General/Hiring) Request Desk: Request More Information');

UPDATE `ohrm_notification_subscriber_subscription_template`
SET `subject` = "Request Desk: Additional Information Needed for %requestType% - %title%",`body` = '<pre style="font-size:12.8px;font-family:  Arial, sans-serif">Hi %recipientFullName%,

 Your request has been reviewed by %infoRequester%. Before we can proceed, we need further information.

 Information Needed: %requestedInfo%
 Request ID: %id%
 Request Title: %title%
 Description: %description%
 Requestor: %requester%
 Request Owner: %requestOwner%
 Resolution Date: %resolutionDate%

 %extraInformation%

Please log in <a href="%link%">here</a> to update your request with further information.

 Thank you.

 This is an automated notification.</pre>'
WHERE `notification_id` = @notification_id;