APPS.ZPB_SC_REASSIGN dependencies on FND_USER

Line 171: l_new_owner_user_name fnd_user.user_name%TYPE;

167: p_new_owner_id IN zpb_analysis_cycles.owner_id%TYPE,
168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
169: IS
170:
171: l_new_owner_user_name fnd_user.user_name%TYPE;
172: l_owner_user_name fnd_user.user_name%TYPE;
173:
174: BEGIN
175:

Line 172: l_owner_user_name fnd_user.user_name%TYPE;

168: p_business_area_id IN zpb_analysis_cycles.business_area_id%TYPE)
169: IS
170:
171: l_new_owner_user_name fnd_user.user_name%TYPE;
172: l_owner_user_name fnd_user.user_name%TYPE;
173:
174: BEGIN
175:
176: zpb_log.write('zpb_sc_reassign. reassign_exception_objs',

Line 181: SELECT user_name INTO l_new_owner_user_name FROM fnd_user WHERE user_id = p_new_owner_id;

177: 'Reassigning Exception objects from user id: ' || p_owner_id ||
178: ' to user id: ' || p_new_owner_id);
179:
180: -- Some columns use text name.
181: SELECT user_name INTO l_new_owner_user_name FROM fnd_user WHERE user_id = p_new_owner_id;
182: SELECT user_name INTO l_owner_user_name FROM fnd_user WHERE user_id = p_owner_id;
183:
184: -- zpb_analysis_cycle_tasks
185: UPDATE

Line 182: SELECT user_name INTO l_owner_user_name FROM fnd_user WHERE user_id = p_owner_id;

178: ' to user id: ' || p_new_owner_id);
179:
180: -- Some columns use text name.
181: SELECT user_name INTO l_new_owner_user_name FROM fnd_user WHERE user_id = p_new_owner_id;
182: SELECT user_name INTO l_owner_user_name FROM fnd_user WHERE user_id = p_owner_id;
183:
184: -- zpb_analysis_cycle_tasks
185: UPDATE
186: zpb_analysis_cycle_tasks