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 1953: from per_time_periods tp,per_assignments_f paf

1949: cursor c_periods (p_assignment_id number
1950: ,p_start_date date
1951: ,p_end_date date) is
1952: select greatest(tp.start_date,paf.effective_start_date) start_date,least(tp.end_date,paf.effective_end_date) end_date
1953: from per_time_periods tp,per_assignments_f paf
1954: where paf.assignment_id = p_assignment_id
1955: and tp.payroll_id = paf.payroll_id
1956: and tp.start_date <= paf.effective_end_date
1957: and tp.end_date >= paf.effective_start_date

Line 2356: from per_time_periods tp

2352: -- cursor to check payroll periods exist up to calc_end_date
2353:
2354: cursor c_last_period (p_payroll_id number) is
2355: select max(tp.end_date)
2356: from per_time_periods tp
2357: where tp.payroll_id = p_payroll_id;
2358: begin
2359:
2360: hr_utility.set_location(' In: ' || l_proc,5) ;