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 3797: from per_time_periods ptp

3793: ,l_date DATE
3794: )
3795: IS
3796: select min(ptp.start_date) next_payroll_date
3797: from per_time_periods ptp
3798: ,per_all_assignments_f paaf
3799: where ptp.payroll_id = paaf.payroll_id
3800: and paaf.assignment_id = l_assignment_id
3801: and ptp.start_date > l_date ;

Line 4366: from per_time_periods ptp

4362: ,p_effective_date DATE
4363: )
4364: IS
4365: select min(ptp.start_date) next_payroll_date
4366: from per_time_periods ptp
4367: ,per_all_assignments_f paaf
4368: where ptp.payroll_id = paaf.payroll_id
4369: and paaf.assignment_id = p_assignment_id
4370: and ptp.start_date > p_effective_date ;

Line 4921: from per_time_periods ptp

4917: ,l_date DATE
4918: )
4919: IS
4920: select min(ptp.start_date) next_payroll_date
4921: from per_time_periods ptp
4922: ,per_all_assignments_f paaf
4923: where ptp.payroll_id = paaf.payroll_id
4924: and paaf.assignment_id = l_assignment_id
4925: and ptp.start_date > l_date ;