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

Line 1227: FROM per_all_people_f person, per_all_assignments_f asg

1223: SELECT person_id, full_name
1224: into l_next_approver_id,l_next_approver_name
1225: FROM (
1226: SELECT person.person_id, person.full_name
1227: FROM per_all_people_f person, per_all_assignments_f asg
1228: WHERE asg.position_id = l_next_approver(1).orig_system_id
1229: and trunc(sysdate) between person.effective_start_date
1230: and nvl(person.effective_end_date, trunc(sysdate))
1231: and person.person_id = asg.person_id