/* $Header: pycnffsp.sql 115.1 2003/03/20 06:10:43 bramajey noship $ */
/* --------------------------------------------------------
-----------------------------------------------------------
FORMULA NAME : CN_SEVERANCE_PAY
FORMULA TYPE : Oracle Payroll
DESCRIPTION : Severance Pay formula for china localization
-----------------------------------------------------------
---------------------------------------------------------*/
/* DEFAULT SECTION */
Default for CN_PAYROLL_RUN_MONTHS is 0
Default for CN_TECHNICAL_HIRE_DATE is '0001/01/01 00:00:00' (date)
Default for CN_ACTUAL_HIRE_DATE is '0001/01/01 00:00:00' (date)
Default for CN_TERMINATION_DATE is '0001/01/01 00:00:00' (date)
Default for average_monthly_salary is 0
/* INPUT SECTION */
Inputs are average_monthly_salary
/* INITIALIZATION SECTION */
l_avg_sal = 0
/* CALCULATION SECTION */
If AVERAGE_MONTHLY_SALARY was defaulted then
l_avg_sal = SEVERANCE_PAY_BASE_SALARY_ASG_P12MTH / CN_PAYROLL_RUN_MONTHS
Else
l_avg_sal = AVERAGE_MONTHLY_SALARY
/* get hire date */
If CN_TECHNICAL_HIRE_DATE was defaulted then
l_hire_date = CN_ACTUAL_HIRE_DATE
else
l_hire_date = CN_TECHNICAL_HIRE_DATE
/* get termination date */
l_termination_date = CN_TERMINATION_DATE