DBA Data[Home] [Help]

APPS.ZPB_SC_REASSIGN dependencies on ZPB_EXCP_RESULTS

Line 249: -- zpb_excp_results owner info

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,

Line 251: zpb_excp_results

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,

Line 271: -- zpb_excp_results approver info

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,

Line 273: zpb_excp_results

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,