The following lines contain the word 'select', 'insert', 'update' or 'delete':
Updated SeaCalc
Removed Tax on Public Office
Fixed Cascading Bug
Override Functionality
Added hr_utility trace
Moved private functions and
procedures to utility package
J.N. Louw 12/04/2000 110.9 Added Calendar Month to Date
Balances to cater for the
calculation of Net Taxable Income
Used in the calculation of the
Skills Development Levy
J.N. Louw 16-03-2000 110.8 bal_TXB_SUBS* deleted:
Subsistence Allowance change
J.N. Louw 06-03-2000 110.7 SitePayeSplit for 'G'
Added balance:
Total Seasonal Workers Days
Worked:
bal_TOT_SEA_WRK_DYS_WRK
trc_MsgTxStatus Now Error State:
FATAL error level
trc_MsgTxStatus removed -
replaced by utility msg
in FND_NEW_MESSAGES -
Fatal message - error state
J.N. Louw 17-02-2000 110.6 Added LteCalc - Late Payments
Merged and Expanded
py_za_tx_utl_01032000.TrvAllYtd
and py_za_tx_utl_01032000.TrvAllCal into
py_za_tx_utl_01032000.TrvAll
Created py_za_tx_utl_01032000.GlbVal function
Created py_za_tx_utl_01032000.LatePayPeriod function
Updated ZaTx_01032000 with
Late Payments checks
Updated py_za_tx_utl_01032000.Abatements with
Late Payments checks
trc_SitFactor now defaults
to 1(One)
Updated Balance Functions
with new balances and
re-ordered
Fixed Excess Arrear Carryover
Fixed 'G' py_za_tx_utl_01032000.SitPaySplit
c/p_PAYE_PTD,p_SITE_PTD,
bal_PAYE_PTD,bal_SITE_PTD
/p_PAYE_YTD,p_SITE_YTD,
bal_PAYE_YTD,bal_SITE_YTD
Updated py_za_tx_utl_01032000.SitPaySplit:
Reset SITE in case of
directive status(C,D,E,F)
J.N. Louw 09-02-2000 110.5 Fixed 65 Rebate and Threshold
Check
Altered Threshold Validation:
NorCalc, SitCalc
Tax on ... Refund
Altered Ytd Income Validation:
DirCalc, NorCalc, SitCalc
Tax on ... Refund
Altered ZaTx_01032000:
Tax Status Validation
Altered py_za_tx_utl_01032000.NpVal:
Override of Liability
J.N. Louw 02-02-2000 110.4 Added
py_za_tx_utl_01032000.PreErnPeriod Function
Addded Balance Feed Functionality
for the Total Taxable Income
balance
bal_PRCH_ANU_TXB_RFI_RUN
Added bal_PAYE_PTD,bal_SITE_PTD
Fixed BasCalc
Added py_za_tx_utl_01032000.LstPeriod
,py_za_tx_utl_01032000.EmpTermInPeriod,
py_za_tx_utl_01032000.EmpTermPrePeriod Functions
Removed TxbIncYtd check in
SitCalc
Fixed De-annualisation of Public
Office Allowance - SitCalc,
SeaCalc
J.N. Louw 20-01-2000 110.3 Fixed bug on py_za_tx_utl_01032000.NpVal
when Net Pay
is zero
J.N. Louw 14-01-2000 110.2 Removed Tot RFI vs
Taxable Income Check from
abatements calculation
J.N. Louw 09-12-1999 110.1 Arrear Excess Processing
J.N. Louw 13-09-1999 110.0 First Created
*/
/* PACKAGE BODY */
PROCEDURE NetTxbIncCalc AS
-- Variable Declaration
nti_CurMthStrtDte DATE;
SELECT trunc(dbi_SES_DTE,'Month')
INTO nti_CurMthStrtDte
FROM dual;
SELECT last_day(dbi_SES_DTE)
INTO nti_CurMthEndDte
FROM dual;
SELECT pbt.balance_type_id
INTO l_BalTypId
FROM pay_balance_types pbt
WHERE pbt.balance_name = p_BalNme;
SELECT pbt.balance_type_id
INTO l_BalTypId
FROM pay_balance_types pbt
WHERE pbt.balance_name = p_BalNme;
SELECT min(ptp.start_date)
INTO l_StrtDte
FROM per_time_periods ptp
WHERE ptp.prd_information1 = trc_AsgTxYear
AND ptp.payroll_id = con_PRL_ID;
SELECT max(ptp.end_date)
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.prd_information1 = trc_AsgTxYear
AND ptp.payroll_id = con_PRL_ID;
SELECT MAX(ptp.end_date) "EndDate"
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.payroll_id = con_PRL_ID
AND ptp.prd_information1 = trc_AsgTxYear
GROUP BY ptp.prd_information1;
SELECT MAX(ptp.end_date) "EndDate"
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.payroll_id = con_PRL_ID
AND ptp.prd_information1 = trc_AsgTxYear
GROUP BY ptp.prd_information1;