The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
,ASSIGN.normal_hours
FROM per_all_assignments_f ASSIGN
where date_earned
BETWEEN ASSIGN.effective_start_date
AND ASSIGN.effective_end_date
and ASSIGN.assignment_id = p_assignment_id;
select ORG_INFORMATION9
from hr_organization_information
where org_information_context = 'Business Group Information'
and organization_id = p_business_group_id;