trying to fetch the Original Hire Date at the Assignment DFF level.

Summary:

I have a requirement to fetch the Original Hire Date at the Assignment DFF level. I have created a table-based value set, but I’m facing issues while calling the bind variable in the query. Has anyone worked on a similar requirement, or is there an alternative approach that can be used to achieve this?

below is the where condition query used for table based value set:

1=1 and paam.PERIOD_OF_SERVICE_ID = ppos.PERIOD_OF_SERVICE_IDand ppos.LEGISLATION_CODE = 'US'and trunc(sysdate) between trunc(paam.EFFECTIVE_START_DATE) and trunc(paam.EFFECTIVE_END_DATE)and paam.ASSIGNMENT_TYPE in ('E', 'P', 'C')and paam.EFFECTIVE_LATEST_CHANGE = 'Y'and paam.assignment_id = :{SEGMENT.ASSIGNMENT_ID}