eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TX_UTL_01032013 dependencies on PER_TIME_PERIODS

Line 568: ,per_time_periods ptp

564: hr_utility.set_location('py_za_tx_utl_01032013.PeriodFactor',4);
565: SELECT count(ptp_all.PERIOD_NAME)
566: INTO l_no_of_periods
567: FROM pay_payroll_actions ppa
568: ,per_time_periods ptp
569: ,per_time_periods ptp_all
570: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
571: and ppa.time_period_id = ptp.time_period_id
572: and ptp_all.payroll_id = ptp.payroll_id

Line 569: ,per_time_periods ptp_all

565: SELECT count(ptp_all.PERIOD_NAME)
566: INTO l_no_of_periods
567: FROM pay_payroll_actions ppa
568: ,per_time_periods ptp
569: ,per_time_periods ptp_all
570: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
571: and ppa.time_period_id = ptp.time_period_id
572: and ptp_all.payroll_id = ptp.payroll_id
573: and ptp_all.prd_information1 = ptp.prd_information1

Line 580: ,per_time_periods ptp

576:
577: SELECT min(ptp_all.end_date ) - min(py_za_tx_01032013.dbi_ZA_ACT_STRT_DTE)+1
578: INTO l_no_of_days
579: FROM pay_payroll_actions ppa
580: ,per_time_periods ptp
581: ,per_time_periods ptp_all
582: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
583: and ppa.time_period_id = ptp.time_period_id
584: and ptp_all.payroll_id = ptp.payroll_id

Line 581: ,per_time_periods ptp_all

577: SELECT min(ptp_all.end_date ) - min(py_za_tx_01032013.dbi_ZA_ACT_STRT_DTE)+1
578: INTO l_no_of_days
579: FROM pay_payroll_actions ppa
580: ,per_time_periods ptp
581: ,per_time_periods ptp_all
582: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
583: and ppa.time_period_id = ptp.time_period_id
584: and ptp_all.payroll_id = ptp.payroll_id
585: and ptp_all.prd_information1 = ptp.prd_information1

Line 759: l_EndDate per_time_periods.end_date%TYPE;

755:
756: -- Variables
757: l_65Year DATE;
758: l_75Year DATE;
759: l_EndDate per_time_periods.end_date%TYPE;
760:
761: l_ZA_TX_YR_END DATE;
762: l_ZA_ADL_TX_RBT t_balance;
763: l_ZA_PRI_TX_RBT t_balance;

Line 845: l_EndDate per_time_periods.end_date%TYPE;

841: PROCEDURE Abatements AS
842:
843: -- Variables
844: l_65Year DATE;
845: l_EndDate per_time_periods.end_date%TYPE;
846:
847: l_ZA_TX_YR_END DATE;
848: l_ZA_ARR_PF_AN_MX_ABT t_balance;
849: l_ZA_ARR_RA_AN_MX_ABT t_balance;