300: elsif ln_asg_set is not null then
301:
302: lv_sql_string :=
303: 'select distinct paf.person_id
304: from hr_assignment_set_amendments asgset,
305: per_assignments_f paf
306: where assignment_set_id = ' || ln_asg_set || '
307: and asgset.assignment_id = paf.assignment_id
308: and asgset.include_or_exclude = ''I''
461: ,cp_end_person in number
462: ,cp_asg_set in number
463: ,cp_effective_date in date) is
464: select distinct paf.person_id
465: from hr_assignment_set_amendments asgset,
466: per_assignments_f paf,
467: pay_payroll_actions ppa,
468: pay_assignment_actions paa
469: where asgset.assignment_set_id = cp_asg_set
485: ,cp_end_person in number
486: ,cp_asg_set in number
487: ,cp_effective_date in date) is
488: select distinct paf.person_id
489: from hr_assignment_set_amendments asgset,
490: per_assignments_f paf,
491: pay_payroll_actions ppa,
492: pay_assignment_actions paa,
493: pay_population_ranges ppr
1409: l_sort3 varchar2(60);
1410: l_year_start date;
1411: l_year_end date;
1412: l_print varchar2(20);
1413: l_asg_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
1414: l_bg_id pay_payroll_actions.business_group_id%type ;
1415:
1416: begin
1417: