APPS.ZPB_WFMNT dependencies on ZPB_PROCESS_DETAILS_V

Line 42: where re.task_id in (select pd.task_id from zpb_process_details_v pd

38: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
39: for v_instance in c_instances loop
40: l_thisInst := v_instance.instance_ac_id;
41: delete from zpb_excp_results re
42: where re.task_id in (select pd.task_id from zpb_process_details_v pd
43: where analysis_cycle_id = l_thisInst);
44: delete from zpb_excp_explanations ex
45: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
46: where analysis_cycle_id = l_thisInst);

Line 45: where ex.task_id in (select pd.task_id from zpb_process_details_v pd

41: delete from zpb_excp_results re
42: where re.task_id in (select pd.task_id from zpb_process_details_v pd
43: where analysis_cycle_id = l_thisInst);
44: delete from zpb_excp_explanations ex
45: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
46: where analysis_cycle_id = l_thisInst);
47: end loop;
48:
49: end loop;