From clause in the value set throwing error.

Summary:

Iam trying to create a value set but the from clause is throwing error.

Content (please ensure you mask any confidential information):

Error: The FROM clause (SELECT (DURATION) DUR,PERSON_ID,ABSENCE_TYPE_ID FROM ANC_PER_ABS_ENTRIES apae WHERE APPROVAL_STATUS_CD NOT IN ('DENIED') AND TO_CHAR(START_DATE,'YYYY') = {PARAMETER.START_DATE} GROUP BY PERSON_ID,ABSENCE_TYPE_ID) is not valid. (FND-2789)
The FROM clause (SELECT (DURATION) DUR,PERSON_ID,ABSENCE_TYPE_ID FROM ANC_PER_ABS_ENTRIES apae WHERE APPROVAL_STATUS_CD NOT IN ('DENIED') AND TO_CHAR(START_DATE,'YYYY') = {PARAMETER.START_DATE} GROUP BY PERSON_ID,ABSENCE_TYPE_ID) is not valid. (FND-2789)