APPS.ZPB_SC_REASSIGN dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 184: -- zpb_analysis_cycle_tasks

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
187: SET
188: owner_id = p_new_owner_id,

Line 186: zpb_analysis_cycle_tasks

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
187: SET
188: owner_id = p_new_owner_id,
189: last_updated_by = fnd_global.USER_ID,
190: last_update_date = SYSDATE,

Line 197: zpb_analysis_cycle_tasks ZACT,

193: owner_id = p_owner_id and
194: analysis_cycle_id in (SELECT
195: distinct(ZACT.analysis_cycle_id)
196: FROM
197: zpb_analysis_cycle_tasks ZACT,
198: zpb_analysis_cycles ZAC
199: WHERE
200: ZACT.analysis_cycle_id =
201: ZAC.analysis_cycle_id and

Line 220: zpb_analysis_cycle_tasks ZACT,

216: task_id in (SELECT
217: ZTP.task_id
218: FROM
219: zpb_task_parameters ZTP,
220: zpb_analysis_cycle_tasks ZACT,
221: zpb_analysis_cycles ZAC
222: WHERE
223: ZTP.task_id = ZACT.task_id and
224: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and

Line 242: zpb_analysis_cycle_tasks ZACT,

238: task_id in (SELECT
239: ZTP.task_id
240: FROM
241: zpb_task_parameters ZTP,
242: zpb_analysis_cycle_tasks ZACT,
243: zpb_analysis_cycles ZAC
244: WHERE
245: ZTP.task_id = ZACT.task_id and
246: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and

Line 264: zpb_analysis_cycle_tasks ZACT,

260: task_id in (SELECT
261: ZTP.task_id
262: FROM
263: zpb_task_parameters ZTP,
264: zpb_analysis_cycle_tasks ZACT,
265: zpb_analysis_cycles ZAC
266: WHERE
267: ZTP.task_id = ZACT.task_id and
268: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and

Line 286: zpb_analysis_cycle_tasks ZACT,

282: task_id in (SELECT
283: ZTP.task_id
284: FROM
285: zpb_task_parameters ZTP,
286: zpb_analysis_cycle_tasks ZACT,
287: zpb_analysis_cycles ZAC
288: WHERE
289: ZTP.task_id = ZACT.task_id and
290: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and

Line 308: zpb_analysis_cycle_tasks ZACT,

304: task_id in (SELECT
305: ZTP.task_id
306: FROM
307: zpb_task_parameters ZTP,
308: zpb_analysis_cycle_tasks ZACT,
309: zpb_analysis_cycles ZAC
310: WHERE
311: ZTP.task_id = ZACT.task_id and
312: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and

Line 331: zpb_analysis_cycle_tasks ZACT,

327: task_id in (SELECT
328: ZTP.task_id
329: FROM
330: zpb_task_parameters ZTP,
331: zpb_analysis_cycle_tasks ZACT,
332: zpb_analysis_cycles ZAC
333: WHERE
334: ZTP.task_id = ZACT.task_id and
335: ZACT.analysis_cycle_id = ZAC.analysis_cycle_id and