GET_VALUE_SET not returning any value in Fast Formula

Summary:

Hi,

I am using the Value Set of Table type in Absence Accrual Matrix formula but it is not returning any value in Fast Formula though scenario is valid.

Expected Table Value set Query :

This query will return the Value as '1' if the Binding/pass parameter of the Person_id exist as Manager in PER_ALL_ASSIGNMENTS_M table

MODULE : Absences

FROM Clause : PER_ASSIGNMENT_SUPERVISORS_F

Value Column Name : 1

WHERE Clause : sysdate between effective_start_date and effective_end_date
and MANAGER_TYPE='LINE_MANAGER' AND person_id = :{PARAMETER.PID}

Fast Formula :

******************************************************

INPUTS ARE IV_ACCRUALPERIODSTARTDATE (DATE)