In table value set how to fetch XML cachedata in Transaction table

Summary:

I am currently using below query in data model and getting correct output. But when moved to value set :

 TABLE(per_bipntf_utility.extractXMLSequenceForEO(txnd.transaction_id,'ElementEntryValueDEO',0)) , this table is not taken properly as the transaction ID highlighted is dynamic.

Any suggestions to use the above in value set to retrieve data properly.

--------------------------------------------------------------------------------------------------------------------

select txnh.transaction_id

FROM  hrc_txn_header txnh, hrc_txn_data txnd,    TABLE(per_bipntf_utility.extractXMLSequenceForEO(txnd.transaction_id,'ElementEntryValueDEO',0)) CompensationDetails    

where txnd.status = 'PENDING'

and txnh.subject_id = :{PARAMETER.P_PERSON_ID}

and txnh.object = 'CMP_VC_PER_ELIG_PLANS'

and txnh.transaction_id = txnd.transaction_id