69: J.N. Louw 13/12/2000 110.12 Upped Header Ver for Patch
70: J.N. Louw 06/12/2000 110.11 Added SetRebates procedure call
71: Modified ZaTx_01032000 with new
72: logic
73: L.J. Kloppers 22-11-2000 115.1 Changed per_time_periods.attribute1
74: to per_time_periods.prd_information1
75: J.N. Louw 28/09/2000 110.10 Check for negative dbi_TX_DIR_VAL
76: dbi_ZA_TX_YR_STRT - 1 for CalCalc
77: Updated SeaCalc
70: J.N. Louw 06/12/2000 110.11 Added SetRebates procedure call
71: Modified ZaTx_01032000 with new
72: logic
73: L.J. Kloppers 22-11-2000 115.1 Changed per_time_periods.attribute1
74: to per_time_periods.prd_information1
75: J.N. Louw 28/09/2000 110.10 Check for negative dbi_TX_DIR_VAL
76: dbi_ZA_TX_YR_STRT - 1 for CalCalc
77: Updated SeaCalc
78: Removed Tax on Public Office
600: -- Set the Site Factor to the value of the previous tax year
601: -- Get the tax year start date
602: SELECT min(ptp.start_date)
603: INTO l_StrtDte
604: FROM per_time_periods ptp
605: WHERE ptp.prd_information1 = trc_AsgTxYear
606: AND ptp.payroll_id = con_PRL_ID;
607:
608: hr_utility.set_location('py_za_tx_01032000.LteCalc',7);
609:
610: -- Get the tax year end date
611: SELECT max(ptp.end_date)
612: INTO l_EndDate
613: FROM per_time_periods ptp
614: WHERE ptp.prd_information1 = trc_AsgTxYear
615: AND ptp.payroll_id = con_PRL_ID;
616:
617: hr_utility.set_location('py_za_tx_01032000.LteCalc',8);
620:
621: -- Get the assignment's previous tax year end date
622: SELECT MAX(ptp.end_date) "EndDate"
623: INTO l_EndDate
624: FROM per_time_periods ptp
625: WHERE ptp.payroll_id = con_PRL_ID
626: AND ptp.prd_information1 = trc_AsgTxYear
627: GROUP BY ptp.prd_information1;
628:
803: -- threshold and rebate figures
804: -- Employee Tax Year Start and End Dates
805: SELECT MAX(ptp.end_date) "EndDate"
806: INTO l_EndDate
807: FROM per_time_periods ptp
808: WHERE ptp.payroll_id = con_PRL_ID
809: AND ptp.prd_information1 = trc_AsgTxYear
810: GROUP BY ptp.prd_information1;
811: