Get Started with Redwood for Oracle Cloud HCM Begin Now
Calculate Absence duration for Payroll period
Summary:
Need to calculate Absence duration for each payroll period.
Content (required):
I'm trying to use GET_ABSENCE_DAYS_PER_TYPE function. I'm trying to pass the start & end dates as PAY_EARN_PERIOD_START, PAY_EARN_PERIOD_END. But Value is not returning
Version (include the version you are using, if applicable):
21d
Code Snippet (add any code snippets that support your topic, if applicable):
DEFAULT FOR PAY_EARN_PERIOD_END IS '2019/01/01' (DATE)
DEFAULT FOR PAY_EARN_PERIOD_START IS '2019/01/01' (DATE)
EFF_YEAR = TO_CHAR(PAY_EARN_PERIOD_END,'YYYY')
l_abs_start_date = PAY_EARN_PERIOD_START
0