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.PER_SSHR_CHANGE_PAY dependencies on PER_TIME_PERIODS

Line 3928: from per_time_periods ptp

3924: ,l_date DATE
3925: )
3926: IS
3927: select min(ptp.start_date) next_payroll_date
3928: from per_time_periods ptp
3929: ,per_all_assignments_f paaf
3930: where ptp.payroll_id = paaf.payroll_id
3931: and paaf.assignment_id = l_assignment_id
3932: and ptp.start_date > l_date ;

Line 4502: from per_time_periods ptp

4498: ,p_effective_date DATE
4499: )
4500: IS
4501: select min(ptp.start_date) next_payroll_date
4502: from per_time_periods ptp
4503: ,per_all_assignments_f paaf
4504: where ptp.payroll_id = paaf.payroll_id
4505: and paaf.assignment_id = p_assignment_id
4506: and ptp.start_date > p_effective_date ;

Line 5059: from per_time_periods ptp

5055: ,l_date DATE
5056: )
5057: IS
5058: select min(ptp.start_date) next_payroll_date
5059: from per_time_periods ptp
5060: ,per_all_assignments_f paaf
5061: where ptp.payroll_id = paaf.payroll_id
5062: and paaf.assignment_id = l_assignment_id
5063: and ptp.start_date > l_date ;