APPS.HR_SPP_EXCEPTION_DATA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 210: hr_all_organization_units org

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
213: and paa.assignment_id = p_assignment_id
214: and p_effective_date between paa.effective_start_date