SQL (or other approach) for bills trapped in 'pending' status?

We are on Polaris 7.8 and recently got the patch for POL-22964, where “Print manual bills are “posting” to the database (removed from NotificationQueue) when staff initiate the post from the staff client Reports and Notices Utility, but these never update from “Pending” to “Billed” in the patron account.” However, the patch only resolves the problem for new bills. I’m trying to find existing print bills stuck in pending status and see if I can update them. However, NotificationQueue is a RESULTS table in the Transactions database, so I don’t really know how to work with it.

I am hoping one of you has attempted to fix the same problem and might be able to share how you approached it.