366: c.region_2 state_code
367: FROM hr_all_organization_units b
368: , hr_locations c
369: , hz_parties p
370: , okc_k_headers_all_b h
371: , okc_k_vers_numbers v
372: , okc_statuses_b sts
373: , okc_k_party_roles_b ro
374: WHERE h.authoring_org_id = b.organization_id
418: c.region_2 state_code
419: FROM hr_all_organization_units b
420: , hr_locations c
421: , hz_parties p
422: , okc_k_headers_all_b h
423: , okc_k_vers_numbers v
424: , okc_statuses_b sts
425: , okc_k_party_roles_b ro
426: WHERE h.authoring_org_id = b.organization_id