[Home] [Help]
269: replace( replace(replace(hoi.org_information1,'-'),'/'),' ')
270: from hr_organization_information hoi
271: where org_information_context = 'Employer Identification'
272: and exists (select 'x'
273: from pay_assignment_actions paa,
274: pay_payroll_actions ppa
275: where ppa.payroll_action_id = paa.payroll_action_id
276: and ppa.business_group_id = cp_business_group_id
277: and ppa.effective_date between cp_start_date
374:
375: lv_sql_string :=
376: 'select distinct paf.person_id
377: from pay_payroll_actions ppa,
378: pay_assignment_actions paa,
379: per_assignments_f paf
380: where ppa.business_group_id = ' || ln_business_group_id || '
381: and ppa.effective_date
382: between to_date(''' || to_char(ld_start_date, 'dd/mm/yyyy')
396: and not exists
397: (select /*+ ORDERED */
398: ''x''
399: from pay_action_interlocks pai,
400: pay_assignment_actions paa1,
401: pay_payroll_actions ppa1
402: where pai.locked_action_id = paa.assignment_action_id
403: and paa1.assignment_action_id = pai.locking_action_id
404: and ppa1.payroll_action_id = paa1.payroll_action_id
455: ppa.effective_date,
456: paa.tax_unit_id,
457: paa.assignment_action_id
458: from pay_payroll_actions ppa,
459: pay_assignment_actions paa,
460: per_assignments_f paf
461: where ppa.business_group_id = cp_business_group_id
462: and ppa.effective_date between cp_start_date
463: and cp_end_date
475: and not exists
476: (select /*+ ORDERED */
477: 'x'
478: from pay_action_interlocks pai,
479: pay_assignment_actions paa1,
480: pay_payroll_actions ppa1
481: where pai.locked_action_id = paa.assignment_action_id
482: and paa1.assignment_action_id = pai.locking_action_id
483: and ppa1.payroll_action_id = paa1.payroll_action_id
554: exit;
555: end if;
556:
557: hr_utility.set_location(gv_package || '.action_creation', 50);
558: select pay_assignment_actions_s.nextval
559: into ln_locking_action_id
560: from dual;
561:
562: -- insert into pay_assignment_actions.
558: select pay_assignment_actions_s.nextval
559: into ln_locking_action_id
560: from dual;
561:
562: -- insert into pay_assignment_actions.
563: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
564: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
565: hr_utility.set_location(gv_package || '.action_creation', 60);
566:
566:
567: -- insert an interlock to this action
568: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
569:
570: update pay_assignment_actions paa
571: set paa.serial_number = ln_assignment_action_id
572: where paa.assignment_action_id = ln_locking_action_id;
573:
574: hr_utility.set_location(gv_package || '.action_creation', 60);
1064: ,nvl(sum(to_number(action_information28)),0) action_information28
1065: ,nvl(sum(to_number(action_information29)),0) action_information29
1066: ,action_information30
1067: from pay_action_information pai,
1068: pay_assignment_actions paa,
1069: pay_payroll_actions ppa -- Bug 3343962
1070: where pai.tax_unit_id = cp_tax_unit_id
1071: and paa.payroll_action_id = cp_payroll_action_id
1072: and ppa.payroll_action_id = cp_payroll_action_id
1121: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information2),action_information2))),0) action_information31 --Added for Bug#9872952
1122: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information5),action_information5))),0) action_information32 --Added for Bug#9872952
1123: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information23),action_information23))),0) action_information33 --Added for Bug#9872952
1124: from pay_action_information pai,
1125: pay_assignment_actions paa,
1126: pay_payroll_actions ppa
1127: where pai.tax_unit_id = cp_tax_unit_id
1128: and paa.payroll_action_id = cp_payroll_action_id
1129: and ppa.payroll_action_id = cp_payroll_action_id