Dear All! We have a requirement for absence approvals as follows

Summary:

Any leaves for the past months applied before 5th of current month should be approved only by line manager and any such leaves applied after 5th of current month should go for manager approval and then to HR approval.

Conditionally:

If leave start date is less than 1st of the sysdate month, and creation date is less than or equal to 5th of sysdate month, approval goes to line manager.

If leave start date is less than 1st of the sysdate month, and creation date is greater than 5th of sysdate month, approval goes to line manager and HR.