APPS.HR_SPP_EXCEPTION_DATA dependencies on PER_ALL_ASSIGNMENTS_F

Line 148: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

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

Line 207: per_all_assignments_f paa,

203: select distinct substr(pap.full_name,1,60),paa.assignment_number,paa.payroll_id,
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

Line 273: per_all_assignments_f paa

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