DBA Data[Home] [Help]

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 459: ,pay_payroll_actions ppa

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
463: WHERE ppf.employee_number = p_employee_number

Line 515: ,pay_payroll_actions ppa

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
519: WHERE ppf.employee_number = p_employee_number

Line 547: ,pay_payroll_actions ppa

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
551: WHERE ppf.employee_number = p_employee_number

Line 580: ,pay_payroll_actions ppa

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
584: WHERE ppf.employee_number = p_employee_number

Line 624: ,pay_payroll_actions ppa

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
628: WHERE paf.business_group_id = p_bus_grp_id

Line 679: ,pay_payroll_actions ppa

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
683: WHERE paf.business_group_id = p_bus_grp_id

Line 1033: ,pay_payroll_actions ppa

1029: ,pay_org_payment_methods_f pop
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