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.JTF_RS_IMP_RES_PVT dependencies on HR_LOCATIONS_ALL

Line 92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645

88: per_all_people_f ppl
89: ,hr_all_organization_units org
90: ,per_assignments_f asg
91: ,per_jobs job
92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
93: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
94: ,per_all_people_f emp
95: WHERE ppl.person_id = l_person_id
96: AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)

Line 151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645

147: per_all_people_f ppl
148: ,hr_all_organization_units org
149: ,per_assignments_f asg
150: ,per_jobs job
151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
152: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
153: ,per_all_people_f emp
154: WHERE ppl.person_id = l_person_id
155: -- AND trunc(sysdate) between trunc(ppl.effective_start_date) and trunc(ppl.effective_end_date)