ICP input value’s List of value is not visible on redwood,

Summary:

Hi everyone,
We are able to retrieve the table values set values on Redwood ICP pages. The value set is fetching the selected employee's dependent name. We identified that this issue is occurring due to the {Parameter.PersonId} in the query.

Value Set Query is below

select ppnf1.display_name
from
per_contact_relationships pcr,
per_person_names_f ppnf,
per_person_names_f ppnf1,
per_persons per
where
sysdate between ppnf.effective_start_date and ppnf.effective_end_date
and ppnf.name_type='GLOBAL'
and sysdate between ppnf1.effective_start_date and ppnf1.effective_end_date
and ppnf1.name_type='GLOBAL'