APPS.PY_ZA_TX_UTL_01032000 dependencies on PER_TIME_PERIODS

Line 273: FROM per_time_periods ptp

269:
270: -- Assignment's Tax Year
271: SELECT ptp.prd_information1
272: INTO py_za_tx_01032000.trc_AsgTxYear
273: FROM per_time_periods ptp
274: WHERE ptp.payroll_id = py_za_tx_01032000.con_PRL_ID
275: AND py_za_tx_01032000.dbi_ZA_ACT_END_DTE BETWEEN ptp.start_date AND ptp.end_date;
276:
277: hr_utility.set_location('py_za_tx_utl_01032000.LatePayPeriod',3);

Line 566: l_EndDate per_time_periods.end_date%TYPE;

562: PROCEDURE SetRebates AS
563:
564: -- Variables
565: l_65Year DATE;
566: l_EndDate per_time_periods.end_date%TYPE;
567:
568: l_ZA_TX_YR_END DATE;
569: l_ZA_ADL_TX_RBT NUMBER(15,2);
570: l_ZA_PRI_TX_RBT NUMBER(15,2);

Line 582: FROM per_time_periods ptp

578: -- Employee Tax Year Start and End Dates
579: --
580: SELECT MAX(ptp.end_date) "EndDate"
581: INTO l_EndDate
582: FROM per_time_periods ptp
583: WHERE ptp.payroll_id = py_za_tx_01032000.con_PRL_ID
584: AND ptp.prd_information1 = py_za_tx_01032000.trc_AsgTxYear
585: GROUP BY ptp.prd_information1;
586:

Line 649: l_EndDate per_time_periods.end_date%TYPE;

645: PROCEDURE Abatements AS
646:
647: -- Variables
648: l_65Year DATE;
649: l_EndDate per_time_periods.end_date%TYPE;
650:
651: l_ZA_TX_YR_END DATE;
652: l_ZA_ARR_PF_AN_MX_ABT NUMBER(15,2);
653: l_ZA_ARR_RA_AN_MX_ABT NUMBER(15,2);

Line 1139: FROM per_time_periods ptp

1135: -- Employee Tax Year Start and End Dates
1136: --
1137: SELECT MAX(ptp.end_date) "EndDate"
1138: INTO l_EndDate
1139: FROM per_time_periods ptp
1140: WHERE ptp.payroll_id = py_za_tx_01032000.con_PRL_ID
1141: AND ptp.prd_information1 = py_za_tx_01032000.trc_AsgTxYear
1142: GROUP BY ptp.prd_information1;
1143:

Line 1542: FROM per_time_periods ptp

1538: SELECT MIN(ptp.start_date) "StartDate"
1539: , MAX(ptp.end_date) "EndDate"
1540: INTO l_StrtDate
1541: , l_EndDate
1542: FROM per_time_periods ptp
1543: WHERE ptp.payroll_id = py_za_tx_01032000.con_PRL_ID
1544: AND ptp.prd_information1 = py_za_tx_01032000.trc_AsgTxYear
1545: GROUP BY ptp.prd_information1;
1546: END IF;

Line 2014: FROM per_time_periods ptp

2010: l_EndDte := py_za_tx_01032000.dbi_ZA_ACT_END_DTE;
2011: -- Get Asg Start Date
2012: SELECT MIN(ptp.start_date)
2013: INTO l_StrtDte
2014: FROM per_time_periods ptp
2015: WHERE ptp.prd_information1 = py_za_tx_01032000.trc_AsgTxYear
2016: AND ptp.payroll_id = py_za_tx_01032000.con_PRL_ID;
2017:
2018: hr_utility.set_location('py_za_tx_utl_01032000.DaysWorked',6);