APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 278: ,pay_element_entries_f peef

274: /* Added join for bug fix 4554812 */
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')

Line 425: , pay_element_entries_f pee1

421: , 'FULL_NAME=P'
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 */

Line 427: , pay_element_entries_f pee2

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
431: , pay_element_entry_values_f peev1

Line 485: , pay_element_entries_f pee1

481: , 'ELEMENT_TYPE_ID=P'
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

Line 487: , pay_element_entries_f pee2

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
491: , pay_element_entry_values_f peev2

Line 536: , pay_element_entries_f pee1

532: , 'PAYROLL_ACTION_ID=C'
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

Line 538: , pay_element_entries_f pee2

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
542: , pay_element_entry_values_f peev2

Line 622: , pay_element_entries_f pee

618: , pay_input_values_f piv2
619: , pay_input_values_f piv4
620: , pay_assignment_actions paa
621: , pay_payroll_actions ppa
622: , pay_element_entries_f pee
623: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
624: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
625: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
626: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 689: , pay_element_entries_f pee

685: , pay_input_values_f piv2
686: , pay_input_values_f piv4
687: , pay_assignment_actions paa
688: , pay_payroll_actions ppa
689: , pay_element_entries_f pee
690: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
691: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
692: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
693: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 756: , pay_element_entries_f pee

752: , pay_input_values_f piv2
753: , pay_input_values_f piv4
754: , pay_assignment_actions paa
755: , pay_payroll_actions ppa
756: , pay_element_entries_f pee
757: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
758: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
759: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
760: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID