86: ,ppl.mailstop
87: FROM
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
145: ,ppl.mailstop
146: FROM
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