APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_ALL_ASSIGNMENTS_F

Line 149: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

145: l_special_ceiling_step_id number;
146: l_ceiling_step_id number;
147: l_step_id number;
148: l_lookup_code varchar2(10);
149: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
150: l_new_sequence_number number;
151: l_flag varchar2(2);
152: l_effective_end_date date;
153: l_grade_spine_id number;

Line 209: per_all_assignments_f paa,

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

Line 275: per_all_assignments_f paa

271: into l_ceiling_step_id, l_special_ceiling_step_id
272: from per_grade_spines_f pgs,
273: per_spinal_point_steps_f sps,
274: per_spinal_point_placements_f spp,
275: per_all_assignments_f paa
276: where pgs.grade_spine_id = sps.grade_spine_id
277: and paa.assignment_id = spp.assignment_id
278: and spp.assignment_id = p_assignment_id
279: and sps.step_id = spp.step_id