DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 484: ,pay_element_types_f petf

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
488: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 658: , pay_element_types_f pet

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 */
662: , pay_input_values_f pivf

Line 718: , pay_element_types_f pet

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

Line 769: , pay_element_types_f pet

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

Line 843: , pay_element_types_f pet1

839: , ROWNUM COUNT1
840: FROM pay_run_results prr1
841: , pay_run_result_values prrv1
842: , pay_run_result_values prrv3
843: , pay_element_types_f pet1
844: , pay_input_values_f piv1
845: , pay_input_values_f piv3
846: , pay_run_results prr2
847: , pay_run_result_values prrv2

Line 849: , pay_element_types_f pet2

845: , pay_input_values_f piv3
846: , pay_run_results prr2
847: , pay_run_result_values prrv2
848: , pay_run_result_values prrv4
849: , pay_element_types_f pet2
850: , pay_input_values_f piv2
851: , pay_input_values_f piv4
852: , pay_assignment_actions paa
853: , pay_payroll_actions ppa

Line 910: , pay_element_types_f pet1

906: , ROWNUM COUNT1
907: FROM pay_run_results prr1
908: , pay_run_result_values prrv1
909: , pay_run_result_values prrv3
910: , pay_element_types_f pet1
911: , pay_input_values_f piv1
912: , pay_input_values_f piv3
913: , pay_run_results prr2
914: , pay_run_result_values prrv2

Line 916: , pay_element_types_f pet2

912: , pay_input_values_f piv3
913: , pay_run_results prr2
914: , pay_run_result_values prrv2
915: , pay_run_result_values prrv4
916: , pay_element_types_f pet2
917: , pay_input_values_f piv2
918: , pay_input_values_f piv4
919: , pay_assignment_actions paa
920: , pay_payroll_actions ppa

Line 977: , pay_element_types_f pet1

973: , ROWNUM COUNT1
974: FROM pay_run_results prr1
975: , pay_run_result_values prrv1
976: , pay_run_result_values prrv3
977: , pay_element_types_f pet1
978: , pay_input_values_f piv1
979: , pay_input_values_f piv3
980: , pay_run_results prr2
981: , pay_run_result_values prrv2

Line 983: , pay_element_types_f pet2

979: , pay_input_values_f piv3
980: , pay_run_results prr2
981: , pay_run_result_values prrv2
982: , pay_run_result_values prrv4
983: , pay_element_types_f pet2
984: , pay_input_values_f piv2
985: , pay_input_values_f piv4
986: , pay_assignment_actions paa
987: , pay_payroll_actions ppa