[Home] [Help]
150: )
151: IS
152: select paa.assignment_Action_id
153: from pay_assignment_actions paa,
154: per_all_assignments_f paf,
155: pay_payroll_actions ppa
156: where ppa.business_group_id = cp_business_group_id
157: and ppa.effective_date between cp_start_date and cp_end_date
158: and ppa.action_type = 'X'
279: hr_utility.set_location(gv_package || '.mark_w2c_range_cursor', 30);
280: lv_sql_string :=
281: 'select distinct paf.person_id
282: from pay_assignment_actions paa,
283: per_all_assignments_f paf,
284: pay_payroll_actions ppa
285: where ppa.business_group_id = '|| ln_business_group_id || '
286: and ppa.effective_date between to_date(''' ||
287: to_char(ld_start_date, 'dd-mon-yyyy') || ''',''dd-mon-yyyy'')
354: paa.tax_unit_id,
355: paf.person_id,
356: paa.assignment_Action_id
357: from pay_assignment_actions paa,
358: per_all_assignments_f paf,
359: pay_payroll_actions ppa
360: where ppa.business_group_id = cp_business_group_id
361: and ppa.effective_date between cp_start_date and cp_end_date
362: and ppa.action_type = 'X'
421: cp_end_date in date) is
422: select ppf.full_name, ppf.national_identifier, ppf.employee_number,
423: paf.assignment_number
424: from per_all_people_f ppf,
425: per_all_assignments_f paf
426: where ppf.person_id = cp_person_id
427: and paf.person_id = ppf.person_id
428: and cp_end_date between ppf.effective_start_date
429: and ppf.effective_end_date
449: ln_w2c_asg_action NUMBER := 0;
450: lv_full_name per_all_people_f.full_name%type;
451: lv_national_identifier per_all_people_f.national_identifier%type;
452: lv_employee_number per_all_people_f.employee_number%type;
453: lv_assignment_number per_all_assignments_f.assignment_number%type;
454: lv_gre_name hr_organization_units.name%type;
455: lv_year varchar2(4) ;
456: lv_creation_date varchar2(20) ;
457: lv_sysdate varchar2(20) ;