Calling Value set from Fast Formula with Date Parameter

Summary:

CALLING VALUE SET WITH DATE PARAMETER IN FAST FORMULA

Content (please ensure you mask any confidential information):

Dear All,

I have a requirement to check whether any accrual adjustment exist for employee or not within Accrual Fast Formula.

In order to get the existing of adjustment record, I have defined Table Based value set as per following query:

SELECT 'Y'
FROM ANC_PER_ACRL_ENTRY_DTLS DT, ANC_ABSENCE_PLANS_F_TL PL
WHERE

DT.PERSON_ID = :{PARAMETER.PERSONID}
AND DT.ADJUSTMENT_REASON = 'CP'
AND DT.PL_ID = PL.ABSENCE_PLAN_ID
AND PL.ABSENCE_PLAN_ID = '300000013350596'