DBA Data[Home] [Help]

APPS.HR_SPP_WI_DATA dependencies on PER_ALL_PEOPLE_F

Line 162: from per_all_people_f pap,

158: hr_utility.set_location(p_spinal_point_id,191);
159:
160: select distinct substr(pap.full_name,1,60) ,paa.assignment_number,substr(org.name,1,60)
161: into l_full_name ,l_assignment_number,l_org_name
162: from per_all_people_f pap,
163: per_all_assignments_f paa,
164: hr_all_organization_units org
165: where pap.person_id = paa.person_id
166: and paa.organization_id = org.organization_id