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

Line 97: FROM per_all_people_f

93: l_num_ids NUMBER := 0;
94:
95: CURSOR r_ids IS
96: SELECT person_id
97: FROM per_all_people_f
98: WHERE full_name = p_resource_name
99: AND trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date);
100:
101: CURSOR p_ids IS

Line 209: FROM per_all_people_f

205: l_num_ids NUMBER := NULL;
206:
207: CURSOR r_ids IS
208: SELECT person_id
209: FROM per_all_people_f
210: WHERE full_name = p_person_name;
211:
212: CURSOR login_id IS
213: SELECT employee_id