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:
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