The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rating_scale_id
INTO l_rating_scale_id
FROM per_rating_scales
WHERE name = p_old_rating_scale_name
AND business_group_id is null;
SELECT rating_scale_id
INTO l_rating_scale_id
FROM per_rating_scales
WHERE name = p_old_rating_scale_name
AND business_group_id = p_business_group_id;
SELECT rating_scale_id
INTO l_rating_scale_id
FROM per_rating_scales
WHERE name = p_rating_scale_name
AND business_group_id is null;
SELECT rating_scale_id
INTO l_rating_scale_id
FROM per_rating_scales
WHERE name = p_rating_scale_name
AND business_group_id = p_business_group_id;
SELECT object_version_number
INTO l_rsc_ovn
FROM per_rating_scales
WHERE name = p_old_rating_scale_name
AND business_group_id is null;
SELECT object_version_number
INTO l_rsc_ovn
FROM per_rating_scales
WHERE name = p_old_rating_scale_name
AND business_group_id = p_business_group_id;
SELECT competence_id
INTO l_competence_id
FROM per_competences_vl
WHERE name = p_competence_name
AND business_group_id is null;
SELECT competence_id
INTO l_competence_id
FROM per_competences_vl
WHERE name = p_competence_name
AND business_group_id = p_business_group_id;
SELECT object_version_number
INTO l_cpn_ovn
FROM per_competences_vl
WHERE name = p_competence_name
AND business_group_id is null;
SELECT object_version_number
INTO l_cpn_ovn
FROM per_competences_vl
WHERE name = p_competence_name
AND business_group_id = p_business_group_id;
SELECT rtl.rating_level_id
INTO l_rating_level_id
FROM per_rating_scales rsc , per_rating_levels rtl
WHERE rtl.name = p_old_rating_level_name
AND rsc.rating_scale_id = rtl.rating_scale_id
AND rsc.name = p_rating_scale_name
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT rtl.rating_level_id
INTO l_rating_level_id
FROM per_competences_vl cpn , per_rating_levels rtl
WHERE rtl.name = p_old_rating_level_name
AND cpn.competence_id = rtl.competence_id
AND cpn.name = p_competence_name
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT rtl.rating_level_id
INTO l_rating_level_id
FROM per_rating_scales rsc , per_rating_levels rtl
WHERE rtl.name = p_rating_level_name
AND rsc.rating_scale_id = rtl.rating_scale_id
AND rsc.name = p_rating_scale_name
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT rtl.rating_level_id
INTO l_rating_level_id
FROM per_competences_vl cpn , per_rating_levels rtl
WHERE rtl.name = p_rating_level_name
AND cpn.competence_id = rtl.competence_id
AND cpn.name = p_competence_name
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT rtl.object_version_number
INTO l_rtl_ovn
FROM per_rating_scales rsc , per_rating_levels rtl
WHERE rtl.name = p_old_rating_level_name
AND rsc.rating_scale_id = rtl.rating_scale_id
AND rsc.name = p_rating_scale_name
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT rtl.object_version_number
INTO l_rtl_ovn
FROM per_competences_vl cpn , per_rating_levels rtl
WHERE rtl.name = p_old_rating_level_name
AND cpn.competence_id = rtl.competence_id
AND cpn.name = p_competence_name
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);
SELECT qualification_type_id
INTO l_qualification_type_id
FROM per_qualification_types_vl
WHERE name = p_qualification_type_name;