Get list of employee's entitlement policys entitlements which have custom unit dates

select * from ENT_ENTITLEMENT
where ENT_ID in (
select ENT_ID from ENT_POLICY_ENTITLEMENT
where ENTPOL_ID in (
select ENTPOL_ID from ENT_EMP_POLICY
where EMP_ID = ?
and ENTEMPPOL_ENABLED = 'Y'
and ? between ENTEMPPOL_START_DATE and ENTEMPPOL_END_DATE
)
and ? between ENTPOLENT_START_DATE and ENTPOLENT_END_DATE
)
and ? between ENT_START_DATE and ENT_END_DATE
and ENT_APPLY_ON_UNIT = 'CUSTOM'

Limiting Entitlement Carry overs

To limit the amount carried over on an entitlement, Max Value and Action on Max is used.

If an employee is setup to receive 40 hour vacation per year and only takes 20 hours, then the next year they would receive another 40 hours giving them a total of 60. If you wanted to not carry over the 20 hours from the previous year, set Max Value to 40 and set Action on Max to com.workbrain.app.modules.entitlements.DefaultEntAction