Flow Schedule FF Not returning any value

Summary:

I am working on a FF type 'Flow Schedule', by effective date we should get the payroll process date.

Created a Value set and FF. Both has valid and while testing offline in sql not getting any value.

Select pay_ff_functions.gvs ('STL_PAYROLL_CALENDAR_VS','|P_EFFECTIVE_DATE='''||'2022/06/12'||'''') VALUE FROM DUAL

==========================

Value set query:

------------------------------

SELECT pact.effective_date

--paa.payroll_rel_action_id payment_rel_action_id, pfv.base_flow_name, pact.effective_date pay_date,paa.serial_number,pact.CREATION_DATE 

 FROM PAY_FLOWS_VL pfv, pay_flow_instances flow, pay_requests req, pay_payroll_actions pact, PAY_PAYROLL_REL_ACTIONS paa, pay_time_periods ptp