APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 76: , hr_organization_information hoi1

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

Line 77: , hr_organization_information hoi2

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
80: , pay_all_payrolls_f pap
81: , pay_external_accounts pea

Line 111: , hr_organization_information hoi1

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

Line 112: , hr_organization_information hoi2

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

Line 210: , hr_organization_information hoi1

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

Line 211: , hr_organization_information hoi2

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