245: ZTP.task_id = ZACT.task_id and
246: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
247: ZAC.business_area_id = p_business_area_id);
248:
249: -- zpb_excp_results owner info
250: UPDATE
251: zpb_excp_results
252: SET
253: owner_id = p_new_owner_id,
247: ZAC.business_area_id = p_business_area_id);
248:
249: -- zpb_excp_results owner info
250: UPDATE
251: zpb_excp_results
252: SET
253: owner_id = p_new_owner_id,
254: owner = l_new_owner_user_name,
255: last_updated_by = fnd_global.USER_ID,
267: ZTP.task_id = ZACT.task_id and
268: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and
269: ZAC.business_area_id = p_business_area_id);
270:
271: -- zpb_excp_results approver info
272: UPDATE
273: zpb_excp_results
274: SET
275: approver_id = p_new_owner_id,
269: ZAC.business_area_id = p_business_area_id);
270:
271: -- zpb_excp_results approver info
272: UPDATE
273: zpb_excp_results
274: SET
275: approver_id = p_new_owner_id,
276: approver = l_new_owner_user_name,
277: last_updated_by = fnd_global.USER_ID,