APPS.HR_SPP_WI_DATA dependencies on PER_ALL_ASSIGNMENTS_F

Line 148: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

144: l_new_value number;
145: l_grade_name per_grades.name%TYPE;
146: l_old_spinal_point_id number;
147: l_new_spinal_point_id number;
148: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
149: l_effective_start_date date;
150: l_org_name varchar2(60);
151:
152: begin

Line 163: per_all_assignments_f paa,

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
167: and paa.assignment_id = p_assignment_id