APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 126: , hr_organization_information hoi1

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
130: , pay_all_payrolls_f pap

Line 127: , hr_organization_information hoi2

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
130: , pay_all_payrolls_f pap
131: , pay_payment_types ppt

Line 190: , hr_organization_information hoi1

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
194: , pay_all_payrolls_f pap

Line 191: , hr_organization_information hoi2

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
194: , pay_all_payrolls_f pap
195: , pay_external_accounts pea

Line 229: , hr_organization_information hoi1

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
233: AND hoi1.organization_id = hou.organization_id

Line 230: , hr_organization_information hoi2

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
233: AND hoi1.organization_id = hou.organization_id
234: AND hoi1.org_information_context='CLASS'

Line 300: , hr_organization_information hoi1

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
304: AND hoi1.organization_id = hou.organization_id

Line 301: , hr_organization_information hoi2

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
304: AND hoi1.organization_id = hou.organization_id
305: AND hoi1.org_information_context='CLASS'

Line 415: , hr_organization_information hoi1

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
419: AND hoi1.organization_id = hou.organization_id

Line 416: , hr_organization_information hoi2

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
419: AND hoi1.organization_id = hou.organization_id
420: AND hoi1.org_information_context='CLASS'