476: SELECT hoi2.org_information9
477: FROM pay_assignment_actions paa,
478: pay_payroll_actions ppa,
479: hr_organization_units hou,
480: hr_organization_information hoi1,
481: hr_organization_information hoi2
482: WHERE paa.payroll_action_id = ppa.payroll_action_id
483: AND ppa.business_group_id = hou.organization_id
484: AND hou.organization_id = hoi1.organization_id
477: FROM pay_assignment_actions paa,
478: pay_payroll_actions ppa,
479: hr_organization_units hou,
480: hr_organization_information hoi1,
481: hr_organization_information hoi2
482: WHERE paa.payroll_action_id = ppa.payroll_action_id
483: AND ppa.business_group_id = hou.organization_id
484: AND hou.organization_id = hoi1.organization_id
485: AND hoi1.organization_id = hoi2.organization_id