Getting ERP Transaction Approver details

Summary:

Getting ERP Transaction Approver details

Content (required):

Hi Team,

How do we get the assignee details/pending approver details for ERP Transactions?

Below query works for HCM transactions but not for ERP ones-

SELECT

  (select distinct papf.person_number from per_all_people_f papf where 1=1

  and papf.person_id = hth.subject_id) person_number,

  htce.console_txn_status,

  htce.transaction_id,

  wft.assignees

  FROM hrc_txn_header hth,

  hrc_txn_console_entry htce,

  fa_fusion_soainfra.wftask wft

  WHERE 1=1

  and htce.console_txn_status not in ('ORA_HRC_TXN_DRAFT','ORA_HRC_TXN_COMPLETED')  

  and htce.transaction_id =hth.transaction_id