APPS.PY_ZA_TX_01032000 dependencies on PER_TIME_PERIODS

Line 73: L.J. Kloppers 22-11-2000 115.1 Changed per_time_periods.attribute1

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

Line 74: to per_time_periods.prd_information1

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

Line 604: FROM per_time_periods ptp

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);

Line 613: FROM per_time_periods ptp

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);

Line 624: FROM per_time_periods ptp

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:

Line 807: FROM per_time_periods ptp

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: