481: /*, hr_organization_units hou */
482: /* Added for Pension changes */
483: ,pay_element_entries_f peef
484: ,pay_element_types_f petf
485: ,pay_input_values_f pivf
486: ,pay_element_entry_values_f peev
487: ,per_assignment_status_types past -- 8501177
488: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
489: AND paf.business_group_id = ppa.business_group_id
658: , pay_element_types_f pet
659: , pay_element_entries_f pee2
660: , hr_organization_units hou /*bug fix 4551283*/
661: /* Added for Pension changes */
662: , pay_input_values_f pivf
663: , pay_element_entry_values_f peev1
664: , pay_element_entry_values_f peev2
665: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
666: AND paa.payroll_action_id = ppa.payroll_action_id
717: , pay_element_entries_f pee1
718: , pay_element_types_f pet
719: , pay_element_entries_f pee2
720: /* Added for Pension changes */
721: , pay_input_values_f pivf
722: , pay_element_entry_values_f peev1
723: , pay_element_entry_values_f peev2
724: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
725: AND paa.payroll_action_id = ppa.payroll_action_id
768: , pay_element_entries_f pee1
769: , pay_element_types_f pet
770: , pay_element_entries_f pee2
771: /* Added for Pension changes */
772: , pay_input_values_f pivf
773: , pay_element_entry_values_f peev1
774: , pay_element_entry_values_f peev2
775: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
776: AND paa.payroll_action_id = ppa.payroll_action_id
840: FROM pay_run_results prr1
841: , pay_run_result_values prrv1
842: , pay_run_result_values prrv3
843: , pay_element_types_f pet1
844: , pay_input_values_f piv1
845: , pay_input_values_f piv3
846: , pay_run_results prr2
847: , pay_run_result_values prrv2
848: , pay_run_result_values prrv4
841: , pay_run_result_values prrv1
842: , pay_run_result_values prrv3
843: , pay_element_types_f pet1
844: , pay_input_values_f piv1
845: , pay_input_values_f piv3
846: , pay_run_results prr2
847: , pay_run_result_values prrv2
848: , pay_run_result_values prrv4
849: , pay_element_types_f pet2
846: , pay_run_results prr2
847: , pay_run_result_values prrv2
848: , pay_run_result_values prrv4
849: , pay_element_types_f pet2
850: , pay_input_values_f piv2
851: , pay_input_values_f piv4
852: , pay_assignment_actions paa
853: , pay_payroll_actions ppa
854: , pay_element_entries_f pee
847: , pay_run_result_values prrv2
848: , pay_run_result_values prrv4
849: , pay_element_types_f pet2
850: , pay_input_values_f piv2
851: , pay_input_values_f piv4
852: , pay_assignment_actions paa
853: , pay_payroll_actions ppa
854: , pay_element_entries_f pee
855: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
907: FROM pay_run_results prr1
908: , pay_run_result_values prrv1
909: , pay_run_result_values prrv3
910: , pay_element_types_f pet1
911: , pay_input_values_f piv1
912: , pay_input_values_f piv3
913: , pay_run_results prr2
914: , pay_run_result_values prrv2
915: , pay_run_result_values prrv4
908: , pay_run_result_values prrv1
909: , pay_run_result_values prrv3
910: , pay_element_types_f pet1
911: , pay_input_values_f piv1
912: , pay_input_values_f piv3
913: , pay_run_results prr2
914: , pay_run_result_values prrv2
915: , pay_run_result_values prrv4
916: , pay_element_types_f pet2
913: , pay_run_results prr2
914: , pay_run_result_values prrv2
915: , pay_run_result_values prrv4
916: , pay_element_types_f pet2
917: , pay_input_values_f piv2
918: , pay_input_values_f piv4
919: , pay_assignment_actions paa
920: , pay_payroll_actions ppa
921: , pay_element_entries_f pee
914: , pay_run_result_values prrv2
915: , pay_run_result_values prrv4
916: , pay_element_types_f pet2
917: , pay_input_values_f piv2
918: , pay_input_values_f piv4
919: , pay_assignment_actions paa
920: , pay_payroll_actions ppa
921: , pay_element_entries_f pee
922: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
974: FROM pay_run_results prr1
975: , pay_run_result_values prrv1
976: , pay_run_result_values prrv3
977: , pay_element_types_f pet1
978: , pay_input_values_f piv1
979: , pay_input_values_f piv3
980: , pay_run_results prr2
981: , pay_run_result_values prrv2
982: , pay_run_result_values prrv4
975: , pay_run_result_values prrv1
976: , pay_run_result_values prrv3
977: , pay_element_types_f pet1
978: , pay_input_values_f piv1
979: , pay_input_values_f piv3
980: , pay_run_results prr2
981: , pay_run_result_values prrv2
982: , pay_run_result_values prrv4
983: , pay_element_types_f pet2
980: , pay_run_results prr2
981: , pay_run_result_values prrv2
982: , pay_run_result_values prrv4
983: , pay_element_types_f pet2
984: , pay_input_values_f piv2
985: , pay_input_values_f piv4
986: , pay_assignment_actions paa
987: , pay_payroll_actions ppa
988: , pay_element_entries_f pee
981: , pay_run_result_values prrv2
982: , pay_run_result_values prrv4
983: , pay_element_types_f pet2
984: , pay_input_values_f piv2
985: , pay_input_values_f piv4
986: , pay_assignment_actions paa
987: , pay_payroll_actions ppa
988: , pay_element_entries_f pee
989: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')