APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 311: ,pay_assignment_actions paa

307: FROM per_assignments_f paf
308: ,per_people_f ppf
309: ,pay_element_types_f pet
310: ,pay_input_values_f piv
311: ,pay_assignment_actions paa
312: ,pay_run_results prr
313: ,pay_run_result_values prrv
314: ,per_periods_of_service ppos
315: ,pay_element_classifications pec

Line 362: FROM pay_assignment_actions paa

358: ,p_bus_grp_id NUMBER
359: ,p_term_date DATE )
360: IS
361: SELECT max(paa.assignment_action_id)
362: FROM pay_assignment_actions paa
363: ,pay_payroll_actions ppa
364: ,per_people_f ppf
365: ,per_assignments_f paf
366: ,per_periods_of_service ppos

Line 418: FROM pay_assignment_actions paa

414: ,p_term_date DATE
415: ,p_process_date DATE)
416: IS
417: SELECT max(paa.assignment_action_id)
418: FROM pay_assignment_actions paa
419: ,pay_payroll_actions ppa
420: ,per_people_f ppf
421: ,per_assignments_f paf
422: ,per_periods_of_service ppos

Line 450: FROM pay_assignment_actions paa

446: ,p_bus_grp_id NUMBER
447: ,p_term_date DATE )
448: IS
449: SELECT max(paa.assignment_action_id)
450: FROM pay_assignment_actions paa
451: ,pay_payroll_actions ppa
452: ,per_people_f ppf
453: ,per_assignments_f paf
454: ,per_periods_of_service ppos

Line 483: FROM pay_assignment_actions paa

479: ,p_term_date DATE
480: ,p_process_date DATE)
481: IS
482: SELECT max(paa.assignment_action_id)
483: FROM pay_assignment_actions paa
484: ,pay_payroll_actions ppa
485: ,per_people_f ppf
486: ,per_assignments_f paf
487: ,per_periods_of_service ppos

Line 527: ,pay_assignment_actions paa

523: ,pay_element_entries_f pee
524: ,pay_element_entry_values_f peev
525: ,pay_element_classifications pec
526: ,pay_element_links_f pel
527: ,pay_assignment_actions paa
528: ,pay_payroll_actions ppa
529: ,pay_run_results prr
530: ,pay_run_result_values prrv
531: ,per_periods_of_service ppos

Line 582: ,pay_assignment_actions paa

578: ,pay_input_values_f piv
579: ,pay_element_entries_f pee
580: ,pay_element_classifications pec
581: ,pay_element_links_f pel
582: ,pay_assignment_actions paa
583: ,pay_payroll_actions ppa
584: ,pay_run_results prr
585: ,pay_run_result_values prrv
586: ,per_periods_of_service ppos

Line 635: ,pay_assignment_actions paa

631: FROM per_assignments_f paf
632: ,per_people_f ppf
633: ,pay_element_types_f pet
634: ,pay_input_values_f piv
635: ,pay_assignment_actions paa
636: ,pay_run_results prr
637: ,pay_run_result_values prrv
638: ,per_periods_of_service ppos
639: ,pay_element_classifications pec

Line 691: ,pay_assignment_actions paa

687: FROM per_assignments_f paf
688: ,per_people_f ppf
689: ,pay_element_types_f pet
690: ,pay_input_values_f piv
691: ,pay_assignment_actions paa
692: ,pay_run_results prr
693: ,pay_run_result_values prrv
694: ,per_periods_of_service ppos
695: ,pay_element_classifications pec

Line 743: ,pay_assignment_actions paa

739: FROM per_assignments_f paf
740: ,per_people_f ppf
741: ,pay_element_types_f pet
742: ,pay_input_values_f piv
743: ,pay_assignment_actions paa
744: ,pay_run_results prr
745: ,pay_run_result_values prrv
746: ,per_periods_of_service ppos
747: ,pay_element_classifications pec

Line 791: ,pay_assignment_actions paa

787: FROM per_assignments_f paf
788: ,per_people_f ppf
789: ,pay_element_types_f pet
790: ,pay_input_values_f piv
791: ,pay_assignment_actions paa
792: ,pay_run_results prr
793: ,pay_run_result_values prrv
794: ,per_periods_of_service ppos
795: ,pay_element_classifications pec

Line 854: ,pay_assignment_actions paa

850: FROM per_assignments_f paf
851: ,per_people_f ppf
852: ,pay_element_types_f pet
853: ,pay_input_values_f piv
854: ,pay_assignment_actions paa
855: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
856: ,pay_run_results prr
857: ,pay_run_result_values prrv
858: ,per_periods_of_service ppos

Line 897: ,pay_assignment_actions paa

893: , paa.assignment_action_id)) amount
894: , pbt.balance_name description
895: FROM per_assignments_f paf
896: ,per_people_f ppf
897: ,pay_assignment_actions paa
898: ,per_periods_of_service ppos
899: ,pay_balance_types pbt
900: ,pay_balance_dimensions pbd
901: ,pay_defined_balances pdb

Line 937: ,pay_assignment_actions paa

933: ,pay_personal_payment_methods_f ppm
934: ,pay_payment_types ppt
935: ,pay_action_interlocks pci
936: ,pay_payroll_actions ppa
937: ,pay_assignment_actions paa
938: ,per_people_f ppf
939: ,per_assignments_f paf
940: ,per_periods_of_service ppos
941: WHERE ppp.assignment_action_id = pci.locking_action_id

Line 976: ,pay_assignment_actions paa

972: , paa.assignment_action_id)) amount
973: , pbt.balance_name description
974: FROM per_assignments_f paf
975: ,per_people_f ppf
976: ,pay_assignment_actions paa
977: ,per_periods_of_service ppos
978: ,pay_balance_types pbt
979: ,pay_balance_dimensions pbd
980: ,pay_defined_balances pdb

Line 997: l_asg_max_run_action_id pay_assignment_actions.assignment_action_id%TYPE;-- Bug 4774108 addition

993: AND pdb.balance_dimension_id = pbd.balance_dimension_id
994: AND ppos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
995: AND ppos.actual_termination_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
996:
997: l_asg_max_run_action_id pay_assignment_actions.assignment_action_id%TYPE;-- Bug 4774108 addition
998: --
999: --
1000: --
1001: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition

Line 1003: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;

999: --
1000: --
1001: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1002: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1003: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1004: --
1005: l_procedure VARCHAR2(250);
1006: l_message VARCHAR2(250);
1007: BEGIN