The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from pa_project_parties pp
where pp.project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id
and pp.end_date_active is NULL;
select start_date_active, end_date_active
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id
order by start_date_active; /* Important to process in order. Please do not remove. */
select max(end_date_active)
into l_member_end_date_active
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id;
select min(start_date_active)
into l_min_member_start_date
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id;
select min(start_date_active)
into l_min_member_start_date
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id;
select min(start_date_active)
into l_min_member_start_date
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_proj_role_id;
select p.project_id
from pa_projects_all p
where p.segment1 between p_project_num_from and p_project_num_to
and p.carrying_out_organization_id = nvl(p_project_org, p.carrying_out_organization_id)
and p.project_type = nvl(p_project_type, p.project_type);
select distinct t.task_manager_person_id
from pa_tasks t
where t.project_id = p_project_id
and t.task_manager_person_id is not null;
select 1
from pa_tasks t
where t.project_id = p_project_id
and t.task_manager_person_id = p_task_manager_person_id
and t.completion_date is NULL;
select 1
from pa_project_parties
where project_id = p_project_id
and resource_source_id = p_task_manager_person_id
and project_role_id = p_project_role;
select project_role_type
into l_role_type
from pa_project_role_types
where project_role_id = p_project_role;
select min(nvl(t.start_date,l_project_start_date)), max(completion_date)
into l_start_date_active, l_end_date_active
from pa_tasks t
where t.project_id = l_selprojs_rec.project_id
and t.task_manager_person_id = l_seltaskmgrs_rec.task_manager_person_id;
select segment1
into l_proj_num
from pa_projects_all
where project_id = p_project_id;
select employee_name
into l_emp_name
from pa_employees_res_v
where person_id = p_task_manager_person_id;
select length(p_message)
into len_msg
from dual;
SELECT IMP.Set_Of_Books_ID
INTO l_sob_id
FROM PA_Implementations IMP;
SELECT SUBSTRB(GL.Name, 1, 30)
INTO l_sob_name
FROM GL_Sets_Of_Books GL
WHERE GL.Set_Of_Books_ID = l_sob_id;
SELECT ' '||rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
INTO l_tblock
FROM DUAL;
SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')
INTO l_tblock
FROM DUAL;
SELECT l_tmp_str||' '||l_tmp_str2||' '||l_tmp_str3
INTO l_tblock
FROM DUAL;