APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 140: , pay_assignment_actions paa

136: FROM per_all_assignments_f paf
137: , per_all_people_f pap
138: , hr_soft_coding_keyflex scl
139: , pay_payroll_actions ppa
140: , pay_assignment_actions paa
141: , pay_pre_payments ppp
142: , pay_external_accounts pea
143: , pay_personal_payment_methods_f ppm
144: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 270: , pay_assignment_actions paa

266: FROM per_all_assignments_f paf
267: , per_all_people_f pap
268: , hr_soft_coding_keyflex scl
269: , pay_payroll_actions ppa
270: , pay_assignment_actions paa
271: , pay_pre_payments ppp
272: , pay_external_accounts pea
273: , pay_personal_payment_methods_f ppm
274: /* Added join for bug fix 4554812 */

Line 368: , pay_assignment_actions paa

364: FROM per_all_assignments_f paf
365: , per_all_people_f pap
366: , hr_soft_coding_keyflex scl
367: , pay_payroll_actions ppa
368: , pay_assignment_actions paa
369: , pay_pre_payments ppp
370: , pay_external_accounts pea
371: , pay_personal_payment_methods_f ppm
372: /* Added join for bug fix 4554812 */

Line 424: , pay_assignment_actions paa

420: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
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*/

Line 484: , pay_assignment_actions paa

480: , to_char(pee1.element_entry_id)
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 */

Line 535: , pay_assignment_actions paa

531: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
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 */

Line 620: , pay_assignment_actions paa

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
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

Line 687: , pay_assignment_actions paa

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
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

Line 754: , pay_assignment_actions paa

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
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