Value set table result empty but not the SQL statement

Summary:

Hi All,

In fast formula for compensation, we calling a value set by using GET_VALUE_SET function, but it is not returning any data.

When I execute the SQL statement from the value set, I get some data :
VALUE SET NAME : TEST_VS
Select asg.****_ATTRIBUTE6
From PER_ALL_ASSIGNMENTS_M ASG
Where ASG.ASSIGNMENT_ID = '300000035948702'
AND ASG.assignment_type = 'E'
and asg.person_ID='300000030509268'
AND to_date('2023/12/31','YYYY/MM/DD') between ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE

When I try to test my value set with the following statement, it doesn't work :