The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION delete_sch_elig_obj(p_subscription_guid IN RAW
,p_event IN OUT NOCOPY wf_event_t
) RETURN VARCHAR2 IS
-- In Params
l_bg_id NUMBER;
SELECT elig_obj_id
,object_version_number
FROM ben_elig_obj_f
WHERE business_group_id = cp_bg_id
AND table_name = 'CAC_SR_SCHEDULES_VL'
AND column_name = 'SCHEDULE_ID'
AND column_value = cp_sch_id
AND cp_eff_dt BETWEEN effective_start_date AND effective_end_date;
l_routine := 'delete_sch_elig_obj';
l_mode := 'DELETE';
ben_elig_obj_api.delete_elig_obj
(p_elig_obj_id => l_elig_obj_id
,p_effective_date => l_sch_start_date
,p_object_version_number => l_ovn
,p_datetrack_mode => l_mode
,p_effective_start_date => l_eff_start_dt
,p_effective_end_date => l_eff_end_dt
);
END delete_sch_elig_obj;