202: -- the current year for which SOE is being viewed
203: CURSOR c_get_assignments (c_assignment_id number,c_period_end_date date)
204: IS
205: select distinct paa1.assignment_id
206: from per_assignments_f paa,
207: per_assignments_f paa1,
208: per_people_f ppa
209: where paa.assignment_id = c_assignment_id
210: and paa.person_id = ppa.person_id
203: CURSOR c_get_assignments (c_assignment_id number,c_period_end_date date)
204: IS
205: select distinct paa1.assignment_id
206: from per_assignments_f paa,
207: per_assignments_f paa1,
208: per_people_f ppa
209: where paa.assignment_id = c_assignment_id
210: and paa.person_id = ppa.person_id
211: and paa1.person_id = ppa.person_id