APPS.PY_ZA_TX_UTL_01082000 dependencies on PER_TIME_PERIODS

Line 392: FROM per_time_periods ptp

388:
389: -- Assignment's Tax Year
390: SELECT ptp.prd_information1
391: INTO py_za_tx_01082000.trc_AsgTxYear
392: FROM per_time_periods ptp
393: WHERE ptp.payroll_id = py_za_tx_01082000.con_PRL_ID
394: AND py_za_tx_01082000.dbi_ZA_ACT_END_DTE BETWEEN ptp.start_date AND ptp.end_date;
395:
396: hr_utility.set_location('py_za_tx_utl_01082000.LatePayPeriod',3);

Line 706: l_EndDate per_time_periods.end_date%TYPE;

702: PROCEDURE SetRebates AS
703:
704: -- Variables
705: l_65Year DATE;
706: l_EndDate per_time_periods.end_date%TYPE;
707:
708: l_ZA_TX_YR_END DATE;
709: l_ZA_ADL_TX_RBT NUMBER(15,2);
710: l_ZA_PRI_TX_RBT NUMBER(15,2);

Line 722: FROM per_time_periods ptp

718: -- Employee Tax Year Start and End Dates
719: --
720: SELECT MAX(ptp.end_date) "EndDate"
721: INTO l_EndDate
722: FROM per_time_periods ptp
723: WHERE ptp.payroll_id = py_za_tx_01082000.con_PRL_ID
724: AND ptp.prd_information1 = py_za_tx_01082000.trc_AsgTxYear
725: GROUP BY ptp.prd_information1;
726:

Line 789: l_EndDate per_time_periods.end_date%TYPE;

785: PROCEDURE Abatements AS
786:
787: -- Variables
788: l_65Year DATE;
789: l_EndDate per_time_periods.end_date%TYPE;
790:
791: l_ZA_TX_YR_END DATE;
792: l_ZA_ARR_PF_AN_MX_ABT NUMBER(15,2);
793: l_ZA_ARR_RA_AN_MX_ABT NUMBER(15,2);

Line 1799: FROM per_time_periods ptp

1795: -- Employee Tax Year Start and End Dates
1796: --
1797: SELECT MAX(ptp.end_date) "EndDate"
1798: INTO l_EndDate
1799: FROM per_time_periods ptp
1800: WHERE ptp.payroll_id = py_za_tx_01082000.con_PRL_ID
1801: AND ptp.prd_information1 = py_za_tx_01082000.trc_AsgTxYear
1802: GROUP BY ptp.prd_information1;
1803:

Line 2281: FROM per_time_periods ptp

2277: SELECT MIN(ptp.start_date) "StartDate"
2278: , MAX(ptp.end_date) "EndDate"
2279: INTO l_StrtDate
2280: , l_EndDate
2281: FROM per_time_periods ptp
2282: WHERE ptp.payroll_id = py_za_tx_01082000.con_PRL_ID
2283: AND ptp.prd_information1 = py_za_tx_01082000.trc_AsgTxYear
2284: GROUP BY ptp.prd_information1;
2285: END IF;

Line 2759: FROM per_time_periods ptp

2755: l_EndDte := py_za_tx_01082000.dbi_ZA_ACT_END_DTE;
2756: -- Get Asg Start Date
2757: SELECT MIN(ptp.start_date)
2758: INTO l_StrtDte
2759: FROM per_time_periods ptp
2760: WHERE ptp.prd_information1 = py_za_tx_01082000.trc_AsgTxYear
2761: AND ptp.payroll_id = py_za_tx_01082000.con_PRL_ID;
2762:
2763: hr_utility.set_location('py_za_tx_utl_01082000.DaysWorked',7);