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 1226: FROM per_all_people_f person, per_all_assignments_f asg

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

Line 4790: from per_all_people_f hre

4786: l_value VARCHAR2(1000) := '';
4787: begin
4788: select distinct full_name
4789: into l_value
4790: from per_all_people_f hre
4791: where hre.person_id = p_approver_id
4792: and trunc(sysdate) BETWEEN effective_start_date
4793: and effective_end_date;
4794: