276: /*, hr_organization_units hou */
277: /* Added for Pension changes */
278: ,pay_element_entries_f peef
279: ,pay_element_types_f petf
280: ,pay_input_values_f pivf
281: ,pay_element_entry_values_f peev
282: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
283: AND paf.business_group_id = ppa.business_group_id
284: AND paf.payroll_id = ppa.payroll_id
426: , pay_element_types_f pet
427: , pay_element_entries_f pee2
428: , hr_organization_units hou /*bug fix 4551283*/
429: /* Added for Pension changes */
430: , pay_input_values_f pivf
431: , pay_element_entry_values_f peev1
432: , pay_element_entry_values_f peev2
433: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
434: AND paa.payroll_action_id = ppa.payroll_action_id
485: , pay_element_entries_f pee1
486: , pay_element_types_f pet
487: , pay_element_entries_f pee2
488: /* Added for Pension changes */
489: , pay_input_values_f pivf
490: , pay_element_entry_values_f peev1
491: , pay_element_entry_values_f peev2
492: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
493: AND paa.payroll_action_id = ppa.payroll_action_id
536: , pay_element_entries_f pee1
537: , pay_element_types_f pet
538: , pay_element_entries_f pee2
539: /* Added for Pension changes */
540: , pay_input_values_f pivf
541: , pay_element_entry_values_f peev1
542: , pay_element_entry_values_f peev2
543: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
544: AND paa.payroll_action_id = ppa.payroll_action_id
608: FROM pay_run_results prr1
609: , pay_run_result_values prrv1
610: , pay_run_result_values prrv3
611: , pay_element_types_f pet1
612: , pay_input_values_f piv1
613: , pay_input_values_f piv3
614: , pay_run_results prr2
615: , pay_run_result_values prrv2
616: , pay_run_result_values prrv4
609: , pay_run_result_values prrv1
610: , pay_run_result_values prrv3
611: , pay_element_types_f pet1
612: , pay_input_values_f piv1
613: , pay_input_values_f piv3
614: , pay_run_results prr2
615: , pay_run_result_values prrv2
616: , pay_run_result_values prrv4
617: , pay_element_types_f pet2
614: , pay_run_results prr2
615: , pay_run_result_values prrv2
616: , pay_run_result_values prrv4
617: , pay_element_types_f pet2
618: , pay_input_values_f piv2
619: , pay_input_values_f piv4
620: , pay_assignment_actions paa
621: , pay_payroll_actions ppa
622: , pay_element_entries_f pee
615: , pay_run_result_values prrv2
616: , pay_run_result_values prrv4
617: , pay_element_types_f pet2
618: , pay_input_values_f piv2
619: , pay_input_values_f piv4
620: , pay_assignment_actions paa
621: , pay_payroll_actions ppa
622: , pay_element_entries_f pee
623: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
675: FROM pay_run_results prr1
676: , pay_run_result_values prrv1
677: , pay_run_result_values prrv3
678: , pay_element_types_f pet1
679: , pay_input_values_f piv1
680: , pay_input_values_f piv3
681: , pay_run_results prr2
682: , pay_run_result_values prrv2
683: , pay_run_result_values prrv4
676: , pay_run_result_values prrv1
677: , pay_run_result_values prrv3
678: , pay_element_types_f pet1
679: , pay_input_values_f piv1
680: , pay_input_values_f piv3
681: , pay_run_results prr2
682: , pay_run_result_values prrv2
683: , pay_run_result_values prrv4
684: , pay_element_types_f pet2
681: , pay_run_results prr2
682: , pay_run_result_values prrv2
683: , pay_run_result_values prrv4
684: , pay_element_types_f pet2
685: , pay_input_values_f piv2
686: , pay_input_values_f piv4
687: , pay_assignment_actions paa
688: , pay_payroll_actions ppa
689: , pay_element_entries_f pee
682: , pay_run_result_values prrv2
683: , pay_run_result_values prrv4
684: , pay_element_types_f pet2
685: , pay_input_values_f piv2
686: , pay_input_values_f piv4
687: , pay_assignment_actions paa
688: , pay_payroll_actions ppa
689: , pay_element_entries_f pee
690: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
742: FROM pay_run_results prr1
743: , pay_run_result_values prrv1
744: , pay_run_result_values prrv3
745: , pay_element_types_f pet1
746: , pay_input_values_f piv1
747: , pay_input_values_f piv3
748: , pay_run_results prr2
749: , pay_run_result_values prrv2
750: , pay_run_result_values prrv4
743: , pay_run_result_values prrv1
744: , pay_run_result_values prrv3
745: , pay_element_types_f pet1
746: , pay_input_values_f piv1
747: , pay_input_values_f piv3
748: , pay_run_results prr2
749: , pay_run_result_values prrv2
750: , pay_run_result_values prrv4
751: , pay_element_types_f pet2
748: , pay_run_results prr2
749: , pay_run_result_values prrv2
750: , pay_run_result_values prrv4
751: , pay_element_types_f pet2
752: , pay_input_values_f piv2
753: , pay_input_values_f piv4
754: , pay_assignment_actions paa
755: , pay_payroll_actions ppa
756: , pay_element_entries_f pee
749: , pay_run_result_values prrv2
750: , pay_run_result_values prrv4
751: , pay_element_types_f pet2
752: , pay_input_values_f piv2
753: , pay_input_values_f piv4
754: , pay_assignment_actions paa
755: , pay_payroll_actions ppa
756: , pay_element_entries_f pee
757: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')