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.HRI_OLTP_DISC_WRKFRC dependencies on PER_ALL_PEOPLE_F

Line 831: FROM per_all_assignments_f asg, per_all_people_f peo

827: -- 17-OCT-2001, bug 2052714, fixed to exclude terminated direct reports from the count
828: --
829:
830: SELECT count(*) INTO v_direct_reports
831: FROM per_all_assignments_f asg, per_all_people_f peo
832: WHERE asg.supervisor_id = v_person_id
833: AND v_effective_end_date BETWEEN asg.effective_start_date
834: AND asg.effective_end_date
835: AND asg.person_id = peo.person_id