The following lines contain the word 'select', 'insert', 'update' or 'delete':
update_pcd_sent_dt(p_per_cm_prvdd_id => per_cm_prvdd_id
,p_effective_Date => p_effective_Date );
PROCEDURE update_pcd_sent_dt(p_per_cm_prvdd_id in number
,p_effective_Date in date ) IS
PRAGMA AUTONOMOUS_TRANSACTION;
update ben_per_cm_prvdd_f
set sent_Dt = p_effective_Date
where per_cm_prvdd_id = p_per_cm_prvdd_id
and sent_dt is null
and p_effective_Date between
effective_Start_date and
effective_end_Date ;