Fast Formula to return ineligible when person has applied for same Absence type within 16 days
Summary:
Content (required):
I have created two fast formulas to prevent generating checklist when person applied same Leave type within 16 days period.
One FF is participation and Rate Eligibility
-----------------------------------------------------
********************************************/
assignmentId=GET_CONTEXT(HR_ASSIGNMENT_ID,-1)
personId=GET_CONTEXT(PERSON_ID,-1)
ld_current_date = GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00' (date))
ld_current_date = TO_DATE(GET_VALUE_SET('XX_TEST_ANC_ABS_START_DATE_VS_ONE','|=L_PERSON_ID='''|| TO_CHAR(personId)||''''))
CALL_FORMULA('XX_TEST_ELIGIBILITY_1'
,ELIGIBLE < 'VALID' DEFAULT 'Y')
RETURN ELIGIBLE
------------------------------------------
and this formula calls the Absence Entry validation formula