[Home] [Help]
363: l_report_cat pay_payroll_actions.report_category%type;
364: l_state pay_payroll_actions.report_qualifier%type;
365: l_report_format pay_report_format_mappings_f.report_format%type;
366: -- Variables declared for bug 10399514
367: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
368:
369:
370: lv_serial_number VARCHAR2(30);
371: lv_national_identifier per_all_people_f.national_identifier%type;
380: ,cp_asg_set in number) is
381: select distinct paf.person_id
382: from hr_assignment_set_amendments asgset,
383: per_all_assignments_f paf,
384: pay_assignment_actions paa,
385: pay_payroll_actions ppa
386: where asgset.assignment_set_id = cp_asg_set
387: and asgset.include_or_exclude = 'I'
388: and paf.assignment_id = asgset.assignment_id
405: ,cp_asg_set in number) is
406: select distinct paf.person_id
407: from hr_assignment_set_amendments asgset,
408: per_all_assignments_f paf,
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa,
411: pay_population_ranges ppr
412: where asgset.assignment_set_id = cp_asg_set
413: and asgset.include_or_exclude = 'I'
436: select ppa.report_type,
437: paa.assignment_id,
438: paa.assignment_action_id
439: from pay_payroll_actions ppa,
440: pay_assignment_actions paa
441: where paa.tax_unit_id = cp_tax_unit_id
442: and paa.action_status = 'C'
443: and ppa.business_group_id+0 = ln_business_group_id
444: and ppa.payroll_action_id = paa.payroll_action_id
514:
515: if lv_report_type in ('T4A', 'CAEOY_T4A_AMEND_PP') then
516:
517: /* Create an assignment action for this person */
518: select pay_assignment_actions_s.nextval
519: into ln_t4a_amend_asg_action
520: from dual;
521:
522: hr_utility.trace('New T4A Amendment Action = ' ||
521:
522: hr_utility.trace('New T4A Amendment Action = ' ||
523: to_char(ln_t4a_amend_asg_action));
524:
525: /* Insert into pay_assignment_actions. */
526: hr_utility.trace('creating assignment action');
527: hr_nonrun_asact.insact(ln_t4a_amend_asg_action
528: ,ln_primary_assignment_id
529: ,p_payroll_action_id
536: table */
537:
538: hr_utility.trace('updating assignment action');
539:
540: update pay_assignment_actions aa
541: set aa.serial_number = to_char(p_person_id)
542: where aa.assignment_action_id = ln_t4a_amend_asg_action;
543:
544: /* Interlock the YEPP or Previous T4A Amendment Archiver