[Home] [Help]
124: , pea.segment3
125: FROM hr_organization_units hou
126: , hr_organization_information hoi1
127: , hr_organization_information hoi2
128: , pay_payroll_actions ppa
129: , pay_consolidation_sets pcs
130: , pay_all_payrolls_f pap
131: , pay_payment_types ppt
132: , pay_external_accounts pea
188: , pea.segment3
189: FROM hr_organization_units hou
190: , hr_organization_information hoi1
191: , hr_organization_information hoi2
192: , pay_payroll_actions ppa
193: , pay_consolidation_sets pcs
194: , pay_all_payrolls_f pap
195: , pay_external_accounts pea
196: , pay_org_payment_methods_f pop
223: , 'PAYROLL_ACTION_ID=C'
224: , 'TRANSFER_TYPE=P' --9036229
225: , '20' "type" --9036229
226: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
227: FROM pay_payroll_actions ppa
228: , hr_organization_units hou
229: , hr_organization_information hoi1
230: , hr_organization_information hoi2
231: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
252: , pap.full_name
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
294: , 'PAYROLL_ACTION_ID=C'
295: , pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
296: , 'TRANSFER_TYPE=P'
297: , '90' "type"
298: FROM pay_payroll_actions ppa
299: , hr_organization_units hou
300: , hr_organization_information hoi1
301: , hr_organization_information hoi2
302: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
324: , pap.full_name
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
374: , 'TRANSFER_PBS_NO=P'
375: , puci1.value
376: , 'TRANSFER_RECEIVER_NAME=P'
377: , pur.row_low_range_or_name
378: FROM pay_payroll_actions ppa
379: , pay_user_tables put
380: , pay_user_columns puc
381: , pay_user_column_instances_f puci
382: , pay_user_rows_f pur
409: , 'TRANSFER_PBS_NO=P'
410: , hoi2.ORG_INFORMATION1
411: , 'TRANSFER_RECEIVER_NAME=P'
412: , hou.name
413: FROM pay_payroll_actions ppa
414: , hr_organization_units hou
415: , hr_organization_information hoi1
416: , hr_organization_information hoi2
417: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
470: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
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
595: , fnd_date.date_to_canonical(PAY_DK_PAYMENT_PROCESS_PKG.get_date_earned_context(paa.ASSIGNMENT_ID))
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
651: , 'PAYROLL_ACTION_ID=C'
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
711: , 'ELEMENT_ENTRY_ID=P'
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
762: ,'DATE_EARNED=C'
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
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
857: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
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
924: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
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
991: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID
1046: , nvl(pad.postal_code,0)
1047: FROM per_addresses pad
1048: /* Modified for bug fix 4593682 */
1049: , per_all_people_f pap
1050: , pay_payroll_actions ppa
1051: WHERE pad.person_id (+)= pap.person_id
1052: AND pad.primary_flag = 'Y' --9403004
1053: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,to_date('31-12-4712','dd-mm-rrrr')) --9403004
1054: /* pad.person_id = pay_magtape_generic.get_parameter_value('TRANSFER_PERSON_ID') */