[Home] [Help]
201:
202: lv_sql_string :=
203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id
209: and ppa.payroll_action_id = :p_payroll_action_id
219:
220: lv_sql_string :=
221: 'select distinct paf.person_id
222: from pay_payroll_actions ppa_arch,
223: pay_assignment_actions paa_arch,
224: per_assignments_f paf,
225: pay_payroll_actions ppa
226: where paa_arch.assignment_id = paf.assignment_id
227: and ppa.payroll_action_id = :p_payroll_action_id
276: ln_asg_set NUMBER := 0 ;
277: lv_print varchar2(10);
278:
279: lv_report_type pay_payroll_actions.report_type%TYPE ;
280: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
281:
282: lv_employee_number per_people_f.employee_number%type;
283: lv_message varchar2(100):= null;
284: lv_full_name per_people_f.full_name%type;
282: lv_employee_number per_people_f.employee_number%type;
283: lv_message varchar2(100):= null;
284: lv_full_name per_people_f.full_name%type;
285: lv_record_name varchar2(100);
286: ln_serial_number pay_assignment_actions.serial_number%TYPE;
287: ln_gre_id NUMBER;
288: ln_gre_parameter NUMBER;
289: lv_ppr_report_type varchar2(50);
290:
295: select distinct paf.person_id
296: from hr_assignment_set_amendments asgset,
297: per_assignments_f paf,
298: pay_payroll_actions ppa,
299: pay_assignment_actions paa
300: where asgset.assignment_set_id = cp_asg_set
301: and asgset.include_or_exclude = 'I'
302: and paf.assignment_id = asgset.assignment_id
303: and paf.person_id between cp_start_person
325: AND hoi.org_information_context = 'Canada Employer Identification'
326: AND hoi.org_information5 in ('T4A/RL1','T4A/RL2')
327: AND exists ( SELECT 1
328: FROM pay_payroll_actions ppa ,
329: pay_assignment_actions paa
330: WHERE ppa.report_type = 'CAEOY_T4A_AMEND_PP'
331: AND ppa.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'
332: AND ppa.business_group_id = cp_bg_id
333: AND ppa.effective_date = cp_eff_date
340: cp_start_person number,
341: cp_end_person number) is
342: select distinct paa_arch.serial_number
343: from pay_payroll_actions ppa_arch,
344: pay_assignment_actions paa_arch
345: where ppa_arch.business_group_id = cp_bg_id
346: and ppa_arch.report_type = 'CAEOY_T4A_AMEND_PP'
347: AND ppa_arch.report_qualifier = 'CAEOY_T4A_AMEND_PPQ'
348: and ppa_arch.effective_date = cp_eff_date
364: paa.assignment_id,
365: paa.assignment_action_id,
366: paa.tax_unit_id
367: from pay_payroll_actions ppa,
368: pay_assignment_actions paa
369: where paa.serial_number = to_char(cp_person_id)
370: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
371: and ppa.business_group_id = ln_business_group_id
372: and paa.action_status = 'C'
390: paa.assignment_id,
391: paa.assignment_action_id,
392: paa.tax_unit_id
393: from pay_payroll_actions ppa,
394: pay_assignment_actions paa
395: where paa.serial_number = to_char(cp_person_id)
396: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
397: and ppa.business_group_id = ln_business_group_id
398: and paa.action_status = 'C'
531: /* Create an assignment action for this person */
532: hr_utility.trace('get_latest_t4a_amend_dtls found ');
533: hr_utility.trace('Report Type: '||lv_report_type);
534:
535: select pay_assignment_actions_s.nextval
536: into ln_t4a_amend_reg_asg_action
537: from dual;
538:
539: hr_utility.trace('New T4A Amend Action = ' ||
538:
539: hr_utility.trace('New T4A Amend Action = ' ||
540: to_char(ln_t4a_amend_reg_asg_action));
541:
542: /* Insert into pay_assignment_actions. */
543: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action
544: ,ln_primary_assignment_id
545: ,p_payroll_action_id
546: ,p_chunk
559: ***********************************************************/
560: ln_serial_number := lpad(to_char(ln_asg_act_to_lock),14,0)||
561: lpad(to_char(ln_yepp_pact_id),14,0);
562:
563: update pay_assignment_actions aa
564: set aa.serial_number = ln_serial_number
565: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
566:
567: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
638: hr_utility.trace('Report Type: '||lv_report_type);
639:
640: /* Create an assignment action for this person */
641:
642: select pay_assignment_actions_s.nextval
643: into ln_t4a_amend_reg_asg_action
644: from dual;
645:
646: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);
644: from dual;
645:
646: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);
647:
648: /* Insert into pay_assignment_actions. */
649: hr_nonrun_asact.insact(ln_t4a_amend_reg_asg_action
650: ,ln_primary_assignment_id
651: ,p_payroll_action_id
652: ,p_chunk
668:
669: hr_utility.trace('Archiver Asg Act :'||substr(ln_serial_number,3,14));
670: hr_utility.trace('Archiver PactID :'||substr(ln_serial_number,17,14));
671:
672: update pay_assignment_actions aa
673: set aa.serial_number = ln_serial_number
674: where aa.assignment_action_id = ln_t4a_amend_reg_asg_action;
675:
676: end if; -- lv_amend_flag = 'Y' condition
831: hr_all_organization_units hou1,
832: hr_locations_all loc,
833: per_all_people_f ppf,
834: per_all_assignments_f paf,
835: pay_assignment_actions paa1,
836: pay_payroll_actions ppa1
837: where ppa1.payroll_action_id = :p_payroll_action_id
838: and paa1.payroll_action_id = ppa1.payroll_action_id
839: and paa1.assignment_id = paf.assignment_id