303: hoi3.org_information3 Contact,
304: hoi5.org_information3 Phone
305: from
306: hr_organization_units ou,
307: hr_organization_information hoi1,
308: hr_organization_information hoi2,
309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
304: hoi5.org_information3 Phone
305: from
306: hr_organization_units ou,
307: hr_organization_information hoi1,
308: hr_organization_information hoi2,
309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
312: pay_assignment_actions paa,
305: from
306: hr_organization_units ou,
307: hr_organization_information hoi1,
308: hr_organization_information hoi2,
309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
312: pay_assignment_actions paa,
313: pay_payroll_actions ppa
306: hr_organization_units ou,
307: hr_organization_information hoi1,
308: hr_organization_information hoi2,
309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
312: pay_assignment_actions paa,
313: pay_payroll_actions ppa
314: where
307: hr_organization_information hoi1,
308: hr_organization_information hoi2,
309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
312: pay_assignment_actions paa,
313: pay_payroll_actions ppa
314: where
315: ou.organization_id=hoi1.organization_id