The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT assignment_id
FROM per_assignments_f
WHERE person_id = p_person_id
AND primary_flag = 'Y'
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
PROCEDURE emp_disability_update
(p_effective_date IN DATE
,p_disability_id IN NUMBER
,p_category IN VARCHAR2
,p_status IN VARCHAR2
,p_degree IN NUMBER
,p_dis_information1 IN VARCHAR2
)
IS
--
l_procedure VARCHAR2(100);
SELECT person_id,category,status,degree,dis_information1
FROM per_disabilities_f
WHERE disability_id = p_disability_id
AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
l_procedure := g_package || 'emp_disability_update' ;
END emp_disability_update;