APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_ALL_PEOPLE_F

Line 206: from per_all_people_f pap,

202: hr_utility.set_location('full name and assignment number',120);
203: select distinct substr(pap.full_name,1,60),paa.assignment_number,paa.payroll_id,
204: substr(org.name ,1,60)
205: into l_full_name,l_assignment_number,l_payroll_id,l_org_name
206: from per_all_people_f pap,
207: per_all_assignments_f paa,
208: hr_all_organization_units org
209: where pap.person_id = paa.person_id
210: and paa.organization_id = org.organization_id