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_PEOPLE_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

Line 5117: from per_all_people_f hre

5113: l_value VARCHAR2(1000) := '';
5114: begin
5115: select distinct full_name
5116: into l_value
5117: from per_all_people_f hre
5118: where hre.person_id = p_approver_id
5119: and trunc(sysdate) BETWEEN effective_start_date
5120: and effective_end_date;
5121: