DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 279: ,pay_element_types_f petf

275: /* Removed and re-wrote in function get_pension_provider */
276: /*, hr_organization_units hou */
277: /* Added for Pension changes */
278: ,pay_element_entries_f peef
279: ,pay_element_types_f petf
280: ,pay_input_values_f pivf
281: ,pay_element_entry_values_f peev
282: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
283: AND paf.business_group_id = ppa.business_group_id

Line 426: , pay_element_types_f pet

422: , hou.name /*bug fix 4551283*/
423: FROM pay_payroll_actions ppa
424: , pay_assignment_actions paa
425: , pay_element_entries_f pee1
426: , pay_element_types_f pet
427: , pay_element_entries_f pee2
428: , hr_organization_units hou /*bug fix 4551283*/
429: /* Added for Pension changes */
430: , pay_input_values_f pivf

Line 486: , pay_element_types_f pet

482: , to_char(pet.element_type_id)
483: FROM pay_payroll_actions ppa
484: , pay_assignment_actions paa
485: , pay_element_entries_f pee1
486: , pay_element_types_f pet
487: , pay_element_entries_f pee2
488: /* Added for Pension changes */
489: , pay_input_values_f pivf
490: , pay_element_entry_values_f peev1

Line 537: , pay_element_types_f pet

533: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
534: FROM pay_payroll_actions ppa
535: , pay_assignment_actions paa
536: , pay_element_entries_f pee1
537: , pay_element_types_f pet
538: , pay_element_entries_f pee2
539: /* Added for Pension changes */
540: , pay_input_values_f pivf
541: , pay_element_entry_values_f peev1

Line 611: , pay_element_types_f pet1

607: , ROWNUM COUNT1
608: FROM pay_run_results prr1
609: , pay_run_result_values prrv1
610: , pay_run_result_values prrv3
611: , pay_element_types_f pet1
612: , pay_input_values_f piv1
613: , pay_input_values_f piv3
614: , pay_run_results prr2
615: , pay_run_result_values prrv2

Line 617: , pay_element_types_f pet2

613: , pay_input_values_f piv3
614: , pay_run_results prr2
615: , pay_run_result_values prrv2
616: , pay_run_result_values prrv4
617: , pay_element_types_f pet2
618: , pay_input_values_f piv2
619: , pay_input_values_f piv4
620: , pay_assignment_actions paa
621: , pay_payroll_actions ppa

Line 678: , pay_element_types_f pet1

674: , ROWNUM COUNT1
675: FROM pay_run_results prr1
676: , pay_run_result_values prrv1
677: , pay_run_result_values prrv3
678: , pay_element_types_f pet1
679: , pay_input_values_f piv1
680: , pay_input_values_f piv3
681: , pay_run_results prr2
682: , pay_run_result_values prrv2

Line 684: , pay_element_types_f pet2

680: , pay_input_values_f piv3
681: , pay_run_results prr2
682: , pay_run_result_values prrv2
683: , pay_run_result_values prrv4
684: , pay_element_types_f pet2
685: , pay_input_values_f piv2
686: , pay_input_values_f piv4
687: , pay_assignment_actions paa
688: , pay_payroll_actions ppa

Line 745: , pay_element_types_f pet1

741: , ROWNUM COUNT1
742: FROM pay_run_results prr1
743: , pay_run_result_values prrv1
744: , pay_run_result_values prrv3
745: , pay_element_types_f pet1
746: , pay_input_values_f piv1
747: , pay_input_values_f piv3
748: , pay_run_results prr2
749: , pay_run_result_values prrv2

Line 751: , pay_element_types_f pet2

747: , pay_input_values_f piv3
748: , pay_run_results prr2
749: , pay_run_result_values prrv2
750: , pay_run_result_values prrv4
751: , pay_element_types_f pet2
752: , pay_input_values_f piv2
753: , pay_input_values_f piv4
754: , pay_assignment_actions paa
755: , pay_payroll_actions ppa