[Home] [Help]
246: ln_prev_assignment_id NUMBER := 0;
247: ln_prev_tax_unit_id NUMBER := 0;
248: ld_prev_effective_date DATE;
249: lv_report_type pay_payroll_actions.report_type%TYPE;
250: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
251:
252:
253: lv_serial_number VARCHAR2(30);
254: lv_national_identifier per_all_people_f.national_identifier%type;
263: ,cp_asg_set in number) is
264: select distinct paf.person_id
265: from hr_assignment_set_amendments asgset,
266: per_all_assignments_f paf,
267: pay_assignment_actions paa,
268: pay_payroll_actions ppa
269: where asgset.assignment_set_id = cp_asg_set
270: and asgset.include_or_exclude = 'I'
271: and paf.assignment_id = asgset.assignment_id
290: select ppa.report_type,
291: paa.assignment_id,
292: paa.assignment_action_id
293: from pay_payroll_actions ppa,
294: pay_assignment_actions paa
295: where paa.tax_unit_id = cp_tax_unit_id
296: and paa.action_status = 'C'
297: and ppa.business_group_id+0 = ln_business_group_id
298: and ppa.payroll_action_id = paa.payroll_action_id
368:
369: if lv_report_type in ('T4A', 'CAEOY_T4A_AMEND_PP') then
370:
371: /* Create an assignment action for this person */
372: select pay_assignment_actions_s.nextval
373: into ln_t4a_amend_asg_action
374: from dual;
375:
376: hr_utility.trace('New T4A Amendment Action = ' ||
375:
376: hr_utility.trace('New T4A Amendment Action = ' ||
377: to_char(ln_t4a_amend_asg_action));
378:
379: /* Insert into pay_assignment_actions. */
380: hr_utility.trace('creating assignment action');
381: hr_nonrun_asact.insact(ln_t4a_amend_asg_action
382: ,ln_primary_assignment_id
383: ,p_payroll_action_id
390: table */
391:
392: hr_utility.trace('updating assignment action');
393:
394: update pay_assignment_actions aa
395: set aa.serial_number = to_char(p_person_id)
396: where aa.assignment_action_id = ln_t4a_amend_asg_action;
397:
398: /* Interlock the YEPP or Previous T4A Amendment Archiver