The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
from pa_role_job_bgs
where project_role_id = p_project_role_id
and nvl(business_group_id, -99) = nvl(p_business_group_id, -99)
and role_job_bg_id <> nvl(p_role_job_bg_id, -99);
SELECT job_id
into l_job_id
FROM pa_role_job_bgs
WHERE project_role_id = p_project_role_id
AND nvl(business_group_id, -1) = l_bg_id;
SELECT min_job_level
into l_min_job_level
FROM pa_role_job_bgs
WHERE project_role_id = p_project_role_id
AND nvl(business_group_id, -1) = l_bg_id;
SELECT max_job_level
into l_max_job_level
FROM pa_role_job_bgs
WHERE project_role_id = p_project_role_id
AND nvl(business_group_id, -1) = l_bg_id;