HCM Extract - Unable to get values from fast formulas

Hello, I am trying to get some values which are not coming from the standard attributes in a HCM extract. We developed fast formulas to get these values. The value set queries work fine outside but when the formulas call them, they don't return any value.

So, any suggestions for why these formulas don't return data when run the extract ?

Below is the SQL query :

SELECT 

a.NAME

FROM HR_ALL_ORGANIZATION_UNITS_F_VL a, HR_ORG_UNIT_CLASSIFICATIONS_F b

WHERE 

a.organization_id = b.organization_id

and trunc(sysdate) between a.effective_start_date and a.effective_end_date