GET_VALUE_SET doesn't work in HCM Rates Calculate Value ff but works from oracle payroll

Summary:

Value set returns in oracle payroll fast formula. Does not work in HCM Rates Calculate Value Fast formula

Content (please ensure you mask any confidential information):

Value set tests okay from

SELECT pay_ff_functions.gvs('WI_GET_MAX_CHECK_DATE_VS','|=P_PERSON_ID='''||300000097249847||'''|P_EFF_DATE='''||'2024/11/07'||'''') value from dual

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Value Set Code: GET_MAX_CHECK_DATE_VS

Module: Global Payroll

Validation Type: TableValue Data Type: character

FROM Clause:pay_pay_relationships_dn pprd, pay_payroll_rel_actions pra, pay_payroll_actions ppa2