The following lines contain the word 'select', 'insert', 'update' or 'delete':
REM J.N. Louw 24-Aug-00 115.0 Updated for ZAPatch11i.01
REM L.Kloppers 21-Dec-00 115.1 Put 'create...' on one line
REM P.Vaish 07-JUL-02 115.2 Changed to calculate currect
REM PTO Carry Over as per Legislative Rules.
REM P.Vaish 15-JUL-02 115.3 Changed to calculate the
REM PTO Carry Over for each period correctly.
REM V.Kannan 17-MAR-03 115.4 2848607 Removed the rounding of l_Accrual_Rate in
REM za_pto_annleave_period_loop,which caused the
REM number of days accrued per Period inaccurate.
REM R.Pahune 14-Aug-03 115.5 Added Procedure
REM ZA_PTO_CARRYOVER_RESI_VALUE
REM for the bug no 2932073
REM if the carry over is -ve made it 0
REM along with earlier ZA specific
REM requirements. (code from version
REM 115.20.1158.2 by lklopper)
REM A. Mahanty 05-MAY-05 115.7 4293298 Modified procedure ZA_PTO_CARRYOVER_RESI_VALUE
REM to have correct carryover and
REM net entitlement value when there is
REM negative net entitlement.
REM Kaladhaur P 09-MAR-06 115.8 5043294 Modified procedure ZA_PTO_SICKLEAVE_PERIOD_LOOP
REM to have correct Total Accrued Sick Leave.
REM A. Mahanty 22-SEP-06 115.9 Modified the procedure ZA_PTO_CARRYOVER_RESI_VALUE.
REM The other contributions(leave adjustments) need to
REM be subtracted before the residual value is calculated.
REM The adjustments in the current accrual cycle must not
REM be forfeited.
REM R. Babla 26-NOV-07 115.12 6617789 Modified function ZA_PTO_SICKLEAVE_PERIOD_LOOP to
REM calculate the accrual of 1 for 26 working days for
REM employee's first six months of employment.
==============================================================================*/
/* ======================================================================
Name : ZA_PTO_ANNLEAVE_PERIOD_LOOP
Purpose : This function is called by the ZA_PTO_ANNUAL_LEAVE_MONTHLY_ACCRUAL
formula, and replaces the Sub-Accrual formula which calculated
total PTO accrued per period.
Returns : Total Accrued entitlement
======================================================================*/
function ZA_PTO_ANNLEAVE_PERIOD_LOOP (p_Assignment_ID IN Number
,p_Plan_ID IN Number
,p_Payroll_ID IN Number
,p_calculation_date IN Date)
return number is
l_CSDate date;