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.GHR_SF52_POST_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 195: from per_all_assignments_f asg1,

191:
192:
193: Cursor C_asg_posn is
194: select asg1.assignment_id
195: from per_all_assignments_f asg1,
196: per_all_assignments_f asg
197: where asg.person_id = l_person_id
198: and asg1.person_id <> l_person_id
199: and p_effective_date

Line 196: per_all_assignments_f asg

192:
193: Cursor C_asg_posn is
194: select asg1.assignment_id
195: from per_all_assignments_f asg1,
196: per_all_assignments_f asg
197: where asg.person_id = l_person_id
198: and asg1.person_id <> l_person_id
199: and p_effective_date
200: between asg.effective_start_date and asg.effective_end_date