Orders Awaiting Approval Email Options???

Attempted to redact this screen capture. Running JDE E1 9.2 on 9.2.5.6 tools. Trying to come up with a way to nudge Approvers that are delinquent in Approving Orders, so after like 7 days resend the JDE Email containing the link to Approvals in JDE. I have not found any functional way of doing that within JDE. I believe the JDE Email is driven by a trigger on an INSERT to the F4209, but I think there is more to it than just an INSERT since the emails happen at each level of the Approval Route as it progresses up.

I have also tried to replicate the P43081 logic is SQL. If I could get that accurately, I could send nudge emails via an alternate platform. I can get close, sometimes match exactly what is displayed, but there are some real subtleties and I have not figured them all out. Here is one variation of a SQL Select.