How to add rejection comments to rejection email of a contract

Summary:

We have the new contract approval templates but the query doesn't contain the rejection reason. We need to extend this query to include rejection reason, and then need guidance on how to conditionally display this when the notification was a rejection.

Content (please ensure you mask any confidential information):

How do we get the approval rejection added to the query below?

Version (include the version you are using, if applicable):

26B

Code Snippet (add any code snippets that support your topic, if applicable):

select

bu.name bu_name

, header.CONTRACT_NUMBER

, header.COGNOMEN

, types.name contract_type

, hz.party_name