The following lines contain the word 'select', 'insert', 'update' or 'delete':
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
select formula_id
from ff_compiled_info_f
where formula_id = l_formula_id
and p_session_date between effective_start_date and effective_end_date;
SELECT FORMULA_ID,EFFECTIVE_START_DATE
into l_formula_id,l_effective_start_date
FROM FF_FORMULAS_F fo, ff_formula_types ft
WHERE ft.formula_type_name = 'Oracle Payroll'
and fo.formula_type_id = ft.formula_type_id
and fo.FORMULA_NAME = 'NI_VALIDATION'
AND fo.BUSINESS_GROUP_ID IS NULL
AND fo.LEGISLATION_CODE = p_legislation_code
AND p_session_date BETWEEN fo.EFFECTIVE_START_DATE AND fo.EFFECTIVE_END_DATE;
SELECT org_information9
INTO l_legislation_code
FROM hr_organization_information
WHERE org_information_context = 'Business Group Information'
AND organization_id = p_business_group_id;
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE exists(SELECT '1'
FROM per_all_people_f pp
WHERE (p_person_id IS NULL
OR p_person_id <> pp.person_id)
AND p_national_identifier = pp.national_identifier
AND pp.business_group_id +0 = p_business_group_id);