DBA Data[Home] [Help]

APPS.PY_ZA_TX_01082000 dependencies on PER_TIME_PERIODS

Line 688: FROM per_time_periods ptp

684: -- Set the Site Factor to the value of the previous tax year
685: -- Get the tax year start date
686: SELECT min(ptp.start_date)
687: INTO l_StrtDte
688: FROM per_time_periods ptp
689: WHERE ptp.prd_information1 = trc_AsgTxYear
690: AND ptp.payroll_id = con_PRL_ID;
691:
692: hr_utility.set_location('py_za_tx_01082000.LteCalc',7);

Line 697: FROM per_time_periods ptp

693:
694: -- Get the tax year end date
695: SELECT max(ptp.end_date)
696: INTO l_EndDate
697: FROM per_time_periods ptp
698: WHERE ptp.prd_information1 = trc_AsgTxYear
699: AND ptp.payroll_id = con_PRL_ID;
700:
701: hr_utility.set_location('py_za_tx_01082000.LteCalc',8);

Line 708: FROM per_time_periods ptp

704:
705: -- Get the assignment's previous tax year end date
706: SELECT MAX(ptp.end_date) "EndDate"
707: INTO l_EndDate
708: FROM per_time_periods ptp
709: WHERE ptp.payroll_id = con_PRL_ID
710: AND ptp.prd_information1 = trc_AsgTxYear
711: GROUP BY ptp.prd_information1;
712:

Line 878: FROM per_time_periods ptp

874: -- threshold and rebate figures
875: -- Employee Tax Year Start and End Dates
876: SELECT MAX(ptp.end_date) "EndDate"
877: INTO l_EndDate
878: FROM per_time_periods ptp
879: WHERE ptp.payroll_id = con_PRL_ID
880: AND ptp.prd_information1 = trc_AsgTxYear
881: GROUP BY ptp.prd_information1;
882: