The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gl.name
INTO l_name
FROM gl_sets_of_books gl,pa_implementations pi
WHERE gl.set_of_books_id = pi.set_of_books_id;
select substr(name,1,60) into Org_Name from hr_organization_units
where organization_id = START_ORG_ID;
select meaning into ndf from pa_lookups where
lookup_code = 'NO_DATA_FOUND' and
lookup_type = 'MESSAGE';
select meaning into p_select_column
From pa_lookups
where lookup_code = 'PA_REPORTING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
P_select_column1 := 'pi.org_structure_version_id';
select start_organization_id into start_org_id from pa_implementations;
select meaning into p_select_column
From pa_lookups
where lookup_code = 'PA_EXPENDITURE_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
P_select_column1 := 'pi.exp_org_structure_version_id';
select exp_start_org_id into start_org_id from pa_implementations;
select meaning into p_select_column
From pa_lookups
where lookup_code = 'PA_PROJECT_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
P_select_column1 := 'pi.proj_org_structure_version_id';
select proj_start_org_id into start_org_id from pa_implementations;
P_select_column1 := 'p.organization_id_parent';
select meaning into p_select_column
From pa_lookups
where lookup_code = 'PA_BURDENING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
select distinct organization_id_parent into start_org_id
from per_org_structure_elements a
,pa_implementations b
,hr_organization_information c
where organization_id_parent not in
( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
where d.org_structure_version_id = to_number(c.org_information2)
)
and a.org_structure_version_id = to_number(c.org_information2)
and b.business_group_id = c.organization_id
and c.org_information_context = 'Project Burdening Hierarchy' ;