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

Line 61: from per_assignments_f asg

57: --
58: --
59: cursor csr_future_asg_changes is
60: select 1
61: from per_assignments_f asg
62: where asg.person_id = p_person_id
63: and asg.effective_start_date >= p_hire_date; -- bug 4681265 changed the condition from ' > ' to " >= " .
64: --
65: cursor csr_get_per_details(p_date date) is

Line 87: from per_assignments_f asg,

83: cursor csr_asg_status(p_assignment_id number, p_date date) is
84: select pas.per_system_status
85: , asg.object_version_number
86: , asg.effective_start_date
87: from per_assignments_f asg,
88: per_assignment_status_types pas
89: where asg.assignment_id=p_assignment_id
90: and asg.assignment_status_type_id = pas.assignment_status_type_id
91: and p_date between asg.effective_start_date