[PO] Position Hierarchy Used for PR/PO Approval

A PR/PO was submitted for approval, how to check which Position Hierarchy user used? From Apps front end, it is impossible. Check it out from backend tables.

Sample codes:

SELECT approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT requisition_header_id FROM apps.PO_REQUISITION_HEADERS_ALL WHERE segment1='myPRNumber')

Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.