Consume all leave balances in one application error when below the credit balance
Hi,
I would like to request your assistance to customize the formula for the leave that should consume all leave balances in one application, if the user applied below the credit balance it would be an error.
Please see the provided formula below:
IF ABSENCE_ATTENDANCE_TYPE_ID = 64 AND TO_NUMBER(duration) > TO_NUMBER(l_Maternity_balance) THEN
(
duration = 'FAILED'
invalid_msg = 'Your Maternity Leave Balance is ' +l_Maternity_balance + ' Days, Please apply less than or equl to the same!!'
return duration, invalid_msg
)