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: -- ER FPT
65: cursor fpt_future_asg_changes is

Line 95: from per_assignments_f asg,

91: cursor csr_asg_status(p_assignment_id number, p_date date) is
92: select pas.per_system_status
93: , asg.object_version_number
94: , asg.effective_start_date
95: from per_assignments_f asg,
96: per_assignment_status_types pas
97: where asg.assignment_id=p_assignment_id
98: and asg.assignment_status_type_id = pas.assignment_status_type_id
99: and p_date between asg.effective_start_date