APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 78: , pay_payroll_actions ppa

74: , pea.segment3
75: FROM hr_organization_units hou
76: , hr_organization_information hoi1
77: , hr_organization_information hoi2
78: , pay_payroll_actions ppa
79: , pay_consolidation_sets pcs
80: , pay_all_payrolls_f pap
81: , pay_external_accounts pea
82: , pay_org_payment_methods_f pop

Line 109: FROM pay_payroll_actions ppa

105: , 'TRANSFER_LE_ID=P'
106: , to_char(hou.ORGANIZATION_ID)
107: , 'PAYROLL_ACTION_ID=C'
108: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
109: FROM pay_payroll_actions ppa
110: , hr_organization_units hou
111: , hr_organization_information hoi1
112: , hr_organization_information hoi2
113: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 139: , pay_payroll_actions ppa

135: , pap.full_name
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

Line 173: FROM pay_payroll_actions ppa

169: , 'TRANSFER_PBS_NO=P'
170: , puci1.value
171: , 'TRANSFER_RECEIVER_NAME=P'
172: , pur.row_low_range_or_name
173: FROM pay_payroll_actions ppa
174: , pay_user_tables put
175: , pay_user_columns puc
176: , pay_user_column_instances_f puci
177: , pay_user_rows_f pur

Line 208: FROM pay_payroll_actions ppa

204: , 'TRANSFER_PBS_NO=P'
205: , hoi2.ORG_INFORMATION1
206: , 'TRANSFER_RECEIVER_NAME=P'
207: , hou.name
208: FROM pay_payroll_actions ppa
209: , hr_organization_units hou
210: , hr_organization_information hoi1
211: , hr_organization_information hoi2
212: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 269: , pay_payroll_actions ppa

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

Line 367: , pay_payroll_actions ppa

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

Line 423: FROM pay_payroll_actions ppa

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

Line 483: FROM pay_payroll_actions ppa

479: , 'ELEMENT_ENTRY_ID=P'
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

Line 534: FROM pay_payroll_actions ppa

530: ,'DATE_EARNED=C'
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

Line 621: , pay_payroll_actions ppa

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
625: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID

Line 688: , pay_payroll_actions ppa

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
692: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID

Line 755: , pay_payroll_actions ppa

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
759: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID