Restrict Employees from Requesting Absence Type After Public Holiday Calendar events

Dear Oracle Expert,

We have a requirement to restrict employees from requesting absence type after Public Holiday Calendar events. As a result, we need to develop a fast formula that can prevent the submission of this absence type.

Example:

--------------------

• Public Holiday Calendar Events (Start Date: 01-01-2023, End Date: 02-01-2023).
• The Employee shouldn't be able to request absence on 03-01-2023.

To obtain the Public Holiday start date, I utilized the LOV in the fast formula. The LOV has the following specifications:

FROM Clause: PER_CALENDAR_EVENTS PCE, PER_CALENDAR_EVENTS_TL PCET

Value Column Name: 'PH'

ID Column Name: 'PH'