Example of Element Allocation Formula
The logic for element allocation is written in the formula of type Payroll Run Proration. Here's a sample formula to prorate the monthly earnings into weekly earnings.
default for prorate_start is '0001/01/01 00:00:00' (date)
1. inputs are prorate_start (date),
2. pay_value (number)
3. p1 = 0.10
4. p2 = 0.20
5. p3 = 0.30
6. p4 = 0.35
7. p5 = 0.05
8. l_pay_value = 0
9. wom = 1
10. wom = to_number(TO_CHAR(prorate_start,'W'))
11.
12. temp = PAY_INTERNAL_LOG_WRITE('$# L_WOM : ' + to_char(wom))
13.
14. IF wom = 1 THEN
15. ( l_pay_value = p1*pay_value)
16. ELSE IF wom = 2 THEN
17. ( l_pay_value = p2*pay_value)
18. ELSE IF wom = 3 THEN
19. ( l_pay_value = p3*pay_value)
20. ELSE IF wom = 4 THEN
21. ( l_pay_value = p4*pay_value)
22. ELSE
23. ( l_pay_value = p5*pay_value)
24. temp = PAY_INTERNAL_LOG_WRITE('$# PAY VALUE : ' + to_char(l_pay_value))
25. pay_value= l_pay_value
26. return pay_value