[Home] [Help]
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
367: WHERE ppf.employee_number = p_employee_number
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
423: WHERE ppf.employee_number = p_employee_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
455: WHERE ppf.employee_number = p_employee_number
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
488: WHERE ppf.employee_number = p_employee_number
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
532: WHERE paf.business_group_id = p_bus_grp_id
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
587: WHERE paf.business_group_id = p_bus_grp_id
932: ,pay_org_payment_methods_f pop
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