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

Line 610: SELECT user_name FROM fnd_user fu, per_all_assignments_f asg, per_all_people_f per

606:
607:
608: SELECT user_name INTO l_user_name
609: FROM (
610: SELECT user_name FROM fnd_user fu, per_all_assignments_f asg, per_all_people_f per
611: WHERE asg.position_id = l_next_approvers (i).orig_system_id
612: AND per.person_id = asg.person_id
613: AND fu.employee_id = per.person_id
614: AND TRUNC(SYSDATE) BETWEEN per.effective_start_date AND NVL(per.effective_end_date, TRUNC( SYSDATE))