Is it possible to pull the approvers for Job Requisition Approval?

Summary:

We are trying to create a BI report to know with whom the Job Requisition Approval is pending with. We have used the below query to pull the details but when the Module Identifier is hardcoded the Approvers and Assignee name do not appear. But when we comment /remove the hard coded part the Approver/ Assignee name appear.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT htce.status_category
,htce.created_by
,htce.object_name
,htce.process_category