Oracle Stored Procedure

Create or replace procedure proc_update_staffinfo
Is
Temp number;
Cursor cur_staff is select * From hr_rs_staff where deleted = 0 and sysdate> entryTime + 365;
Begin
For u in cur_staff
Loop
Temp: = Mod (floor (sysdate-to_date (U. entryTime, 'yyyy-mm-dd'), 365 );

If temp <> 0 then
-- Employee enterprise age
Update hr_rs_staff set incluisesage = incluisesage + 1 where id = U. ID;

-- Employee annual leave information
Select count (*) into temp from hr_kq_staffannualleave where id = U. ID;
If temp = 0 then
Insert into hr_kq_staffannualleave (ID, staffid, numberofdays, deleted, createtime, modifytime) values (U. ID, U. ID, 5, 0, sysdate, sysdate );
Else
Update hr_kq_staffannualleave set numberofdays = 40 where id = U. ID;
End if;
End if;
End loop;
End;