Approval Dashboard

can someone please help me to get sql to create approval dashboard which displays approval hierarchy and current status for both requistioning and iExpenses. current sql's I have used can only display current approver instead of all the approvers in the hierarchy. If I use approval history table that doesn't update once the approver delegate the approval to someone else.

Thank you very much in advance.