The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT POSV1.org_structure_version_id
INTO x_org_hierarchy_version_id
FROM per_org_structure_versions POSV1
WHERE POSV1.org_structure_version_id
= p_org_hierarchy_version_id;
SELECT POSV1.org_structure_version_id
INTO x_org_hierarchy_version_id
FROM per_organization_structures POS,
per_org_structure_versions POSV1
WHERE POS.name = p_org_hierarchy_name
AND POS.organization_structure_id =
POSV1.organization_structure_id;
SELECT organization_id
FROM hr_organization_units
WHERE name = p_organization_name;
SELECT organization_id
INTO x_organization_id
FROM hr_all_organization_units -- Bug 4358448 perf change
WHERE organization_id = p_organization_id;
SELECT organization_id
INTO x_organization_id
FROM hr_organization_units
WHERE name = p_organization_name;