How to link TM Record Group to Aprvl TM Record Group in SQL

Hello SQL Gurus!

I'm trying to find a way to link to IDs in a single Query.

• When the project time card approval WF fires I have two APRVL_TM_REC_GRP_ID:
  • One for the project entry rule set that goes to the PM and that fetches reported time
  • One for the timecard approval rule set that goes to the LM and fetches calculated tim

Both APRVL_TM_REC_GRP_ID are pointing to the same TM_REC_GRP_ID based on following query that is used to generate the APproval Notification:

SELECT * FROM TABLE ( hwm_timecard_report.timecard_list(:bindtmrecgrpid1, :bindtmrecgrpid2, :bindtmrecgrpid3, :bindtmrecgrpid4, :bindtmrecgrpid5, :bindaprvtmrecgrpid ))