HR Transaction usefull queries

Transaction statuses
SELECT


Final Status of the transaction:
SELECT PSAH.*
           FROM pqh_ss_approval_history psah
          WHERE psah.transaction_history_id = :Transaction_id
            AND transaction_history_id NOT IN (
                   SELECT transaction_id
                     FROM hr_api_transactions hat, wf_notifications wn
                    WHERE transaction_id = transaction_history_id
                      AND hat.item_key = wn.item_key
                      AND wn.status = 'CLOSED')select * from wf_notifications
where item_key=:item_key * FROM HR_LOOKUPS WHERE LOOKUP_TYPE = 'PQH_SS_TRANSACTION_STATUS'



AME Approvers list will be
-------------------------------
SELECT * FROM AME_TEMP_OLD_APPROVER_LISTS where transaction_id = :tranId
order by order_number
Adhoc appovers from below table
-----------------------------------
AME_TEMP_INSERTIONS