402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_element_types_f pet
405: ,pay_input_values_f piv
406: ,pay_assignment_actions paa
407: ,pay_run_results prr
408: ,pay_run_result_values prrv
409: ,per_periods_of_service ppos
410: ,pay_element_classifications pec
454: ,p_bus_grp_id NUMBER
455: ,p_term_date DATE )
456: IS
457: SELECT max(paa.assignment_action_id)
458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,per_people_f ppf
461: ,per_assignments_f paf
462: ,per_periods_of_service ppos
510: ,p_term_date DATE
511: ,p_process_date DATE)
512: IS
513: SELECT max(paa.assignment_action_id)
514: FROM pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,per_people_f ppf
517: ,per_assignments_f paf
518: ,per_periods_of_service ppos
542: ,p_bus_grp_id NUMBER
543: ,p_term_date DATE )
544: IS
545: SELECT max(paa.assignment_action_id)
546: FROM pay_assignment_actions paa
547: ,pay_payroll_actions ppa
548: ,per_people_f ppf
549: ,per_assignments_f paf
550: ,per_periods_of_service ppos
575: ,p_term_date DATE
576: ,p_process_date DATE)
577: IS
578: SELECT max(paa.assignment_action_id)
579: FROM pay_assignment_actions paa
580: ,pay_payroll_actions ppa
581: ,per_people_f ppf
582: ,per_assignments_f paf
583: ,per_periods_of_service ppos
619: ,pay_element_entries_f pee
620: ,pay_element_entry_values_f peev
621: ,pay_element_classifications pec
622: ,pay_element_links_f pel
623: ,pay_assignment_actions paa
624: ,pay_payroll_actions ppa
625: ,pay_run_results prr
626: ,pay_run_result_values prrv
627: ,per_periods_of_service ppos
674: ,pay_input_values_f piv
675: ,pay_element_entries_f pee
676: ,pay_element_classifications pec
677: ,pay_element_links_f pel
678: ,pay_assignment_actions paa
679: ,pay_payroll_actions ppa
680: ,pay_run_results prr
681: ,pay_run_result_values prrv
682: ,per_periods_of_service ppos
727: FROM per_assignments_f paf
728: ,per_people_f ppf
729: ,pay_element_types_f pet
730: ,pay_input_values_f piv
731: ,pay_assignment_actions paa
732: ,pay_run_results prr
733: ,pay_run_result_values prrv
734: ,per_periods_of_service ppos
735: ,pay_element_classifications pec
783: FROM per_assignments_f paf
784: ,per_people_f ppf
785: ,pay_element_types_f pet
786: ,pay_input_values_f piv
787: ,pay_assignment_actions paa
788: ,pay_run_results prr
789: ,pay_run_result_values prrv
790: ,per_periods_of_service ppos
791: ,pay_element_classifications pec
835: FROM per_assignments_f paf
836: ,per_people_f ppf
837: ,pay_element_types_f pet
838: ,pay_input_values_f piv
839: ,pay_assignment_actions paa
840: ,pay_run_results prr
841: ,pay_run_result_values prrv
842: ,per_periods_of_service ppos
843: ,pay_element_classifications pec
884: FROM per_assignments_f paf
885: ,per_people_f ppf
886: ,pay_element_types_f pet
887: ,pay_input_values_f piv
888: ,pay_assignment_actions paa
889: ,pay_run_results prr
890: ,pay_run_result_values prrv
891: ,per_periods_of_service ppos
892: ,pay_element_classifications pec
947: FROM per_assignments_f paf
948: ,per_people_f ppf
949: ,pay_element_types_f pet
950: ,pay_input_values_f piv
951: ,pay_assignment_actions paa
952: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
953: ,pay_run_results prr
954: ,pay_run_result_values prrv
955: ,per_periods_of_service ppos
990: , paa.assignment_action_id)) amount
991: , pbt.balance_name description
992: FROM per_assignments_f paf
993: ,per_people_f ppf
994: ,pay_assignment_actions paa
995: ,per_periods_of_service ppos
996: ,pay_balance_types pbt
997: ,pay_balance_dimensions pbd
998: ,pay_defined_balances pdb
1030: ,pay_personal_payment_methods_f ppm
1031: ,pay_payment_types ppt
1032: ,pay_action_interlocks pci
1033: ,pay_payroll_actions ppa
1034: ,pay_assignment_actions paa
1035: ,per_people_f ppf
1036: ,per_assignments_f paf
1037: ,per_periods_of_service ppos
1038: WHERE ppp.assignment_action_id = pci.locking_action_id
1069: , paa.assignment_action_id)) amount
1070: , pbt.balance_name description
1071: FROM per_assignments_f paf
1072: ,per_people_f ppf
1073: ,pay_assignment_actions paa
1074: ,per_periods_of_service ppos
1075: ,pay_balance_types pbt
1076: ,pay_balance_dimensions pbd
1077: ,pay_defined_balances pdb
1090: AND pdb.balance_dimension_id = pbd.balance_dimension_id
1091: AND ppos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1092: AND ppos.actual_termination_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1093:
1094: l_asg_max_run_action_id pay_assignment_actions.assignment_action_id%TYPE;-- Bug 4774108 addition
1095: --
1096: --
1097: --
1098: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1096: --
1097: --
1098: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1099: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1100: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: --
1102: l_procedure VARCHAR2(250);
1103: l_message VARCHAR2(250);
1104: BEGIN