310: elsif ln_asg_set is not null then
311:
312: lv_sql_string :=
313: 'select distinct paf.person_id
314: from hr_assignment_set_amendments asgset,
315: per_all_assignments_f paf
316: where assignment_set_id = ' || ln_asg_set || '
317: and asgset.assignment_id = paf.assignment_id
318: and asgset.include_or_exclude = ''I''
409: CURSOR c_selected_asg_set(cp_start_person in number
410: ,cp_end_person in number
411: ,cp_asg_set in number) is
412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf
415: where assignment_set_id = cp_asg_set
416: and asgset.include_or_exclude = 'I'
417: and paf.assignment_id = asgset.assignment_id