[Home] [Help]
270: ln_prev_assignment_id NUMBER := 0;
271: ln_prev_tax_unit_id NUMBER := 0;
272: ld_prev_effective_date DATE ;
273: lv_report_type pay_payroll_actions.report_type%TYPE ;
274: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
275:
276:
277: lv_serial_number VARCHAR2(30);
278: lv_national_identifier per_all_people_f.national_identifier%type;
287: ,cp_asg_set in number) is
288: select distinct paf.person_id
289: from hr_assignment_set_amendments asgset,
290: per_all_assignments_f paf,
291: pay_assignment_actions paa,
292: pay_payroll_actions ppa
293: where asgset.assignment_set_id = cp_asg_set
294: and asgset.include_or_exclude = 'I'
295: and paf.assignment_id = asgset.assignment_id
314: select ppa.report_type,
315: paa.assignment_id,
316: paa.assignment_action_id
317: from pay_payroll_actions ppa,
318: pay_assignment_actions paa
319: where paa.tax_unit_id = cp_tax_unit_id
320: and paa.action_status = 'C'
321: and ppa.payroll_action_id = paa.payroll_action_id
322: and ppa.effective_date = cp_effective_date
391:
392: if lv_report_type in ('T4', 'CAEOY_T4_AMEND_PP') then
393:
394: /* Create an assignment action for this person */
395: select pay_assignment_actions_s.nextval
396: into ln_t4amend_asg_action
397: from dual;
398: hr_utility.trace('New T4 Amendment Action = ' ||
399: to_char(ln_t4amend_asg_action));
397: from dual;
398: hr_utility.trace('New T4 Amendment Action = ' ||
399: to_char(ln_t4amend_asg_action));
400:
401: /* Insert into pay_assignment_actions. */
402: hr_utility.trace('creating asg_action');
403: hr_nonrun_asact.insact(ln_t4amend_asg_action
404: ,ln_primary_assignment_id
405: ,p_payroll_action_id
412: table */
413:
414: hr_utility.trace('updating asg_action');
415:
416: update pay_assignment_actions aa
417: set aa.serial_number = to_char(p_person_id)
418: where aa.assignment_action_id = ln_t4amend_asg_action;
419:
420: /* Interlock the YEPP or Previous T4 Amendment Archiver