APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 483: ,pay_element_entries_f peef

479: /* Added join for bug fix 4554812 */
480: /* Removed and re-wrote in function get_pension_provider */
481: /*, hr_organization_units hou */
482: /* Added for Pension changes */
483: ,pay_element_entries_f peef
484: ,pay_element_types_f petf
485: ,pay_input_values_f pivf
486: ,pay_element_entry_values_f peev
487: ,per_assignment_status_types past -- 8501177

Line 657: , pay_element_entries_f pee1

653: , 'FULL_NAME=P'
654: , hou.name /*bug fix 4551283*/
655: FROM pay_payroll_actions ppa
656: , pay_assignment_actions paa
657: , pay_element_entries_f pee1
658: , pay_element_types_f pet
659: , pay_element_entries_f pee2
660: , hr_organization_units hou /*bug fix 4551283*/
661: /* Added for Pension changes */

Line 659: , pay_element_entries_f pee2

655: FROM pay_payroll_actions ppa
656: , pay_assignment_actions paa
657: , pay_element_entries_f pee1
658: , pay_element_types_f pet
659: , pay_element_entries_f pee2
660: , hr_organization_units hou /*bug fix 4551283*/
661: /* Added for Pension changes */
662: , pay_input_values_f pivf
663: , pay_element_entry_values_f peev1

Line 717: , pay_element_entries_f pee1

713: , 'ELEMENT_TYPE_ID=P'
714: , to_char(pet.element_type_id)
715: FROM pay_payroll_actions ppa
716: , pay_assignment_actions paa
717: , pay_element_entries_f pee1
718: , pay_element_types_f pet
719: , pay_element_entries_f pee2
720: /* Added for Pension changes */
721: , pay_input_values_f pivf

Line 719: , pay_element_entries_f pee2

715: FROM pay_payroll_actions ppa
716: , pay_assignment_actions paa
717: , pay_element_entries_f pee1
718: , pay_element_types_f pet
719: , pay_element_entries_f pee2
720: /* Added for Pension changes */
721: , pay_input_values_f pivf
722: , pay_element_entry_values_f peev1
723: , pay_element_entry_values_f peev2

Line 768: , pay_element_entries_f pee1

764: , 'PAYROLL_ACTION_ID=C'
765: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
766: FROM pay_payroll_actions ppa
767: , pay_assignment_actions paa
768: , pay_element_entries_f pee1
769: , pay_element_types_f pet
770: , pay_element_entries_f pee2
771: /* Added for Pension changes */
772: , pay_input_values_f pivf

Line 770: , pay_element_entries_f pee2

766: FROM pay_payroll_actions ppa
767: , pay_assignment_actions paa
768: , pay_element_entries_f pee1
769: , pay_element_types_f pet
770: , pay_element_entries_f pee2
771: /* Added for Pension changes */
772: , pay_input_values_f pivf
773: , pay_element_entry_values_f peev1
774: , pay_element_entry_values_f peev2

Line 854: , pay_element_entries_f pee

850: , pay_input_values_f piv2
851: , pay_input_values_f piv4
852: , pay_assignment_actions paa
853: , pay_payroll_actions ppa
854: , pay_element_entries_f pee
855: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
856: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
857: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
858: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 921: , pay_element_entries_f pee

917: , pay_input_values_f piv2
918: , pay_input_values_f piv4
919: , pay_assignment_actions paa
920: , pay_payroll_actions ppa
921: , pay_element_entries_f pee
922: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
923: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
924: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
925: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 988: , pay_element_entries_f pee

984: , pay_input_values_f piv2
985: , pay_input_values_f piv4
986: , pay_assignment_actions paa
987: , pay_payroll_actions ppa
988: , pay_element_entries_f pee
989: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
990: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
991: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
992: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID