60: csr_v_upload_date date)
61: IS
62: SELECT SUBSTR (hoi4.org_information1, 4, 2)
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
94: csr_v_upload_date date)
95: IS
96:
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4