Need to update the absence Entry before holiday and after holiday

Summary:

Hi Everyone ,

We have requirement where we have to update absence entry for employees who is in long term absence.

Below is requirement:-

First Step: Check for holidays within the pay period.

If the PLAN_START_DATE falls between the holiday start and end dates, then skip it.
Also, check dates before the holiday start date and after the holiday end date.

Example:
•June 6, 2025, is a holiday.

Evaluation:
•12345 should be skipped because there is no wage continuation after the holiday.
•56780 should be skipped because wage continuation is present on the holiday.
•56781 should be picked because wage continuation is not