Need query for contract approver group
Summary:
For the contract still in live approval cycle (contract in pending approval status), how can I get the approver group name from SQL query?
Here is the SQL I used. It doesn't provide any value for approver group either in assignees field or PARTICIPANTNAME field.
select * from fa_fusion_soainfra.wftaskhistory where taskid in (select task_id from fusion.okc_k_headers_all_b where contract_number = '200024172')
Please advise.
Thanks,
Adam
Content (please ensure you mask any confidential information):
as above
Version (include the version you are using, if applicable):
26C
Code Snippet (add any code snippets that support your topic, if applicable):
0