DBA Data[Home] [Help]

APPS.HR_SPP_EXCEPTION_DATA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 208: hr_all_organization_units org

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