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