APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 125: FROM hr_organization_units hou

121: , 'TRANSFER_PAYER_REG_NO=P'
122: , pea.segment1
123: , 'TRANSFER_PAYER_ACCT_NO=P'
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

Line 189: FROM hr_organization_units hou

185: , 'TRANSFER_PAYER_REG_NO=P'
186: , pea.segment1
187: , 'TRANSFER_PAYER_ACCT_NO=P'
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

Line 228: , hr_organization_units hou

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')
232: AND hou.business_group_id = ppa.business_group_id

Line 299: , hr_organization_units hou

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')
303: AND hou.business_group_id = ppa.business_group_id

Line 414: , hr_organization_units hou

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')
418: AND hou.business_group_id = ppa.business_group_id

Line 481: /*, hr_organization_units hou */

477: , pay_external_accounts pea
478: , pay_personal_payment_methods_f ppm
479: /* Added join for bug fix 4554812 */
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

Line 606: /*, hr_organization_units hou */

602: , pay_external_accounts pea
603: , pay_personal_payment_methods_f ppm
604: /* Added join for bug fix 4554812 */
605: /* Removed and re-wrote in function get_pension_provider */
606: /*, hr_organization_units hou */
607: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
608: AND paf.business_group_id = ppa.business_group_id
609: AND paf.payroll_id = ppa.payroll_id
610: AND pap.per_information_category ='DK'

Line 660: , hr_organization_units hou /*bug fix 4551283*/

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
663: , pay_element_entry_values_f peev1
664: , pay_element_entry_values_f peev2