[Home] [Help]
394: l_report_cat pay_payroll_actions.report_category%type;
395: l_state pay_payroll_actions.report_qualifier%type;
396: l_report_format pay_report_format_mappings_f.report_format%type;
397: -- Variables declared for bug 10399514
398: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
399:
400:
401: lv_serial_number VARCHAR2(30);
402: lv_national_identifier per_all_people_f.national_identifier%type;
411: ,cp_asg_set in number) is
412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf,
415: pay_assignment_actions paa,
416: pay_payroll_actions ppa
417: where asgset.assignment_set_id = cp_asg_set
418: and asgset.include_or_exclude = 'I'
419: and paf.assignment_id = asgset.assignment_id
436: ,cp_asg_set in number) is
437: select distinct paf.person_id
438: from hr_assignment_set_amendments asgset,
439: per_all_assignments_f paf,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa,
442: pay_population_ranges ppr
443: where asgset.assignment_set_id = cp_asg_set
444: and asgset.include_or_exclude = 'I'
467: select ppa.report_type,
468: paa.assignment_id,
469: paa.assignment_action_id
470: from pay_payroll_actions ppa,
471: pay_assignment_actions paa
472: where paa.tax_unit_id = cp_tax_unit_id
473: and paa.action_status = 'C'
474: and ppa.payroll_action_id = paa.payroll_action_id
475: and ppa.effective_date = cp_effective_date
544:
545: if lv_report_type in ('T4', 'CAEOY_T4_AMEND_PP') then
546:
547: /* Create an assignment action for this person */
548: select pay_assignment_actions_s.nextval
549: into ln_t4amend_asg_action
550: from dual;
551: hr_utility.trace('New T4 Amendment Action = ' ||
552: to_char(ln_t4amend_asg_action));
550: from dual;
551: hr_utility.trace('New T4 Amendment Action = ' ||
552: to_char(ln_t4amend_asg_action));
553:
554: /* Insert into pay_assignment_actions. */
555: hr_utility.trace('creating asg_action');
556: hr_nonrun_asact.insact(ln_t4amend_asg_action
557: ,ln_primary_assignment_id
558: ,p_payroll_action_id
565: table */
566:
567: hr_utility.trace('updating asg_action');
568:
569: update pay_assignment_actions aa
570: set aa.serial_number = to_char(p_person_id)
571: where aa.assignment_action_id = ln_t4amend_asg_action;
572:
573: /* Interlock the YEPP or Previous T4 Amendment Archiver