:{PARAMETER.ASSIGNMENT_ID} at assignment dff is not working

Summary:

We have a requirement to store the substantive position, substantive grade, and grade step at the assignment level. For which we are using Assignment DFF. For the substantive grade, we have to capture the employee’s previous grade, and similarly we capture the previous grade step. We are using the table value set for list of values. However, when we use :{PARAMETER.ASSIGNMENT_ID}, it does not return any data. Below is the query we are using for table value set.

Select
pgsf.name
from
per_grade_steps_f_tl pgft
where 1=1
and pgft.language= 'US'
and trunc(sysdate) between pgft.effective_start_date and pgft.effective_end_date