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_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 21934: from per_assignments_f

21930: if g_debug then
21931: hr_utility.set_location(l_proc,100);
21932: end if;
21933: select max(effective_end_date) into l_mx_end_dated
21934: from per_assignments_f
21935: where person_id = l_assignment.person_id
21936: and assignment_type = 'A'
21937: and effective_end_date < hr_general.end_of_time
21938: and assignment_id <> p_assignment_id;

Line 21941: from per_assignments_f

21937: and effective_end_date < hr_general.end_of_time
21938: and assignment_id <> p_assignment_id;
21939: --
21940: select min(effective_start_date) into l_min_no_end_dated
21941: from per_assignments_f
21942: where person_id = l_assignment.person_id
21943: and assignment_type = 'A'
21944: and effective_end_date = hr_general.end_of_time
21945: and assignment_id <> p_assignment_id;