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

Line 731: from per_time_periods tp,per_assignments_f paf

727: cursor c_periods (p_assignment_id number
728: ,p_start_date date
729: ,p_end_date date) is
730: select greatest(tp.start_date,paf.effective_start_date) start_date,least(tp.end_date,paf.effective_end_date) end_date
731: from per_time_periods tp,per_assignments_f paf
732: where paf.assignment_id = p_assignment_id
733: and tp.payroll_id = paf.payroll_id
734: and tp.start_date <= paf.effective_end_date
735: and tp.end_date >= paf.effective_start_date

Line 1134: from per_time_periods tp

1130: -- cursor to check payroll periods exist up to calc_end_date
1131:
1132: cursor c_last_period (p_payroll_id number) is
1133: select max(tp.end_date)
1134: from per_time_periods tp
1135: where tp.payroll_id = p_payroll_id;
1136: begin
1137:
1138: hr_utility.set_location(' In: ' || l_proc,5) ;