The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT business_group_id
FROM per_org_structure_versions
WHERE org_structure_version_id = p_org_structure_version_id;
select legislation_code
into l_legislation_code
from per_business_groups
where business_group_id = p_business_group_id;
'(select organization_id_child '||
'from per_org_structure_elements '||
'connect by organization_id_parent = '||
'prior organization_id_child '||
'and org_structure_version_id = prior org_structure_version_id '||
'start with organization_id_parent = '||
to_char(P_PARENT_ORGANIZATION_ID) ||
' and org_structure_version_id = '||
to_char(P_ORG_STRUCTURE_VERSION_ID) ||
' union select ' ||
to_char(P_PARENT_ORGANIZATION_ID) ||
' from sys.dual)';
select max(effective_end_date) + 1
into l_status_start_date
from per_assignments_f
where assignment_id = p_assignment_id
and assignment_status_type_id <> p_assignment_status_type_id
and effective_end_date < C_SESSION_DATE;
select min(effective_start_date)
into l_status_start_date
from per_assignments_f
where assignment_id = p_assignment_id
and assignment_status_type_id = p_assignment_status_type_id
and effective_start_date <= C_SESSION_DATE;
select min(effective_start_date) - 1
into l_status_end_date
from per_assignments_f
where assignment_id = p_assignment_id
and assignment_status_type_id <> p_assignment_status_type_id
and effective_start_date > C_SESSION_DATE;
select max(effective_end_date)
into l_status_end_date
from per_assignments_f
where assignment_id = p_assignment_id
and assignment_status_type_id = p_assignment_status_type_id
and effective_end_date >= C_SESSION_DATE;