[Home] [Help]
308: ln_prev_assignment_id NUMBER := 0;
309: ln_prev_tax_unit_id NUMBER := 0;
310: ld_prev_effective_date DATE ;
311: lv_report_type pay_payroll_actions.report_type%TYPE ;
312: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
313:
314:
315: lv_serial_number VARCHAR2(30);
316: ln_eoy_pactid number:= 0;
334: per_all_assignments_f paf
335: where assignment_set_id = cp_asg_set
336: and asgset.include_or_exclude = 'I'
337: and paf.assignment_id = asgset.assignment_id
338: --and exists (select 1 from pay_assignment_actions paa
339: -- where paa.assignment_id = asgset.assignment_id
340: -- and paa.payroll_action_id = cp_eoy_pactid)
341: and paf.person_id between cp_start_person
342: and cp_end_person
352: ,cp_start_date in date) is
353: select ppa.report_type, paa.assignment_id,
354: paa.assignment_action_id
355: from pay_payroll_actions ppa,
356: pay_assignment_actions paa,
357: per_assignments_f paf
358: where paa.assignment_id = paf.assignment_id
359: and paf.person_id = cp_person_id
360: and paf.effective_start_date <= cp_effective_date
386: CURSOR get_rehired_emp (cp_person_id in number,cp_tax_unit_id in number
387: ,cp_start_date in date, cp_end_date in date) is
388: SELECT max(paa.assignment_id)
389: FROM
390: pay_assignment_actions paa,
391: per_assignments_f paf,
392: pay_payroll_actions ppa,
393: pay_action_classifications pac
394: WHERE paf.person_id = cp_person_id
455: if get_prev_w2c_dtls%found then
456: if lv_report_type in ('YREND', 'W-2C PAPER','W2C_XML') then
457:
458: /* Create an assignment action for this person */
459: select pay_assignment_actions_s.nextval
460: into ln_w2c_asg_action
461: from dual;
462: hr_utility.trace('New w2c Action = ' ||
463: to_char(ln_w2c_asg_action));
461: from dual;
462: hr_utility.trace('New w2c Action = ' ||
463: to_char(ln_w2c_asg_action));
464:
465: /* Insert into pay_assignment_actions. */
466: hr_utility.trace('creating asg action');
467:
468: /*Bug No. 2819817- pick up latest processed primary assignment
469: In case a terminated employee is rehired and paid, the
494: table */
495:
496: hr_utility.trace('updating asg action');
497:
498: update pay_assignment_actions aa
499: set aa.serial_number = p_person_id
500: where aa.assignment_action_id = ln_w2c_asg_action;
501:
502: /* Interlock the yepp/last w2c report