APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 257: , pay_assignment_actions paa

253: FROM per_all_assignments_f paf
254: , per_all_people_f pap
255: , hr_soft_coding_keyflex scl
256: , pay_payroll_actions ppa
257: , pay_assignment_actions paa
258: , pay_pre_payments ppp
259: , pay_external_accounts pea
260: , pay_personal_payment_methods_f ppm
261: , PAY_ORG_PAYMENT_METHODS_f pop --9036229

Line 329: , pay_assignment_actions paa

325: FROM per_all_assignments_f paf
326: , per_all_people_f pap
327: , hr_soft_coding_keyflex scl
328: , pay_payroll_actions ppa
329: , pay_assignment_actions paa
330: , pay_pre_payments ppp
331: , pay_external_accounts pea
332: , pay_personal_payment_methods_f ppm
333: , PAY_ORG_PAYMENT_METHODS_f pop --9036229

Line 475: , pay_assignment_actions paa

471: FROM per_all_assignments_f paf
472: , per_all_people_f pap
473: , hr_soft_coding_keyflex scl
474: , pay_payroll_actions ppa
475: , pay_assignment_actions paa
476: , pay_pre_payments ppp
477: , pay_external_accounts pea
478: , pay_personal_payment_methods_f ppm
479: /* Added join for bug fix 4554812 */

Line 600: , pay_assignment_actions paa

596: FROM per_all_assignments_f paf
597: , per_all_people_f pap
598: , hr_soft_coding_keyflex scl
599: , pay_payroll_actions ppa
600: , pay_assignment_actions paa
601: , pay_pre_payments ppp
602: , pay_external_accounts pea
603: , pay_personal_payment_methods_f ppm
604: /* Added join for bug fix 4554812 */

Line 656: , pay_assignment_actions paa

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

Line 716: , pay_assignment_actions paa

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

Line 767: , pay_assignment_actions paa

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

Line 852: , pay_assignment_actions paa

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

Line 919: , pay_assignment_actions paa

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

Line 986: , pay_assignment_actions paa

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