APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_ALL_PEOPLE_F

Line 208: from per_all_people_f pap,

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