266:
267: CURSOR chk_appl_user
268: IS
269: SELECT 1 270: FROM FND_USER 271: WHERE employee_id = p_person_id;
272:
273: BEGIN
274:
Line 282: UPDATE FND_USER
278:
279: FOR rec_appl_user in chk_appl_user
280: LOOP
281: BEGIN 282: UPDATE FND_USER 283: SET employee_id = NULL
284: WHERE employee_id = p_person_id;
285: EXCEPTION
286: WHEN OTHERS THEN