Transaction is in "Pending Approval" status but approver did not received notification?

Summary:

We have created a PR document and submitted it for approval. The approval workflow is generated properly, and as per the workflow, the document is assigned to a user. But when we logged in to the user account and checked, the user did not receive any bell notifications. We have also raised an SR to check the root cause of the issue. But simultaneously, we wanted to check: is there a way to find out or identify the exact transaction that is in a pending approval status and the user has not received any notification? May be a SQL query