APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 75: FROM hr_organization_units hou

71: , 'TRANSFER_PAYER_REG_NO=P'
72: , pea.segment1
73: , 'TRANSFER_PAYER_ACCT_NO=P'
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

Line 110: , hr_organization_units hou

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

Line 209: , hr_organization_units hou

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

Line 276: /*, hr_organization_units hou */

272: , pay_external_accounts pea
273: , pay_personal_payment_methods_f ppm
274: /* Added join for bug fix 4554812 */
275: /* Removed and re-wrote in function get_pension_provider */
276: /*, hr_organization_units hou */
277: /* Added for Pension changes */
278: ,pay_element_entries_f peef
279: ,pay_element_types_f petf
280: ,pay_input_values_f pivf

Line 374: /*, hr_organization_units hou */

370: , pay_external_accounts pea
371: , pay_personal_payment_methods_f ppm
372: /* Added join for bug fix 4554812 */
373: /* Removed and re-wrote in function get_pension_provider */
374: /*, hr_organization_units hou */
375: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
376: AND paf.business_group_id = ppa.business_group_id
377: AND paf.payroll_id = ppa.payroll_id
378: AND pap.per_information_category ='DK'

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

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*/
429: /* Added for Pension changes */
430: , pay_input_values_f pivf
431: , pay_element_entry_values_f peev1
432: , pay_element_entry_values_f peev2