APPS.ZPB_WF dependencies on ZPB_PROCESS_DETAILS_V

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

1179: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
1180:
1181: if ACIDType = 'I' then
1182: delete from zpb_excp_results re
1183: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1184: where analysis_cycle_id = inACID);
1185: delete from zpb_excp_explanations ex
1186: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
1187: where analysis_cycle_id = inACID);

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

1182: delete from zpb_excp_results re
1183: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1184: where analysis_cycle_id = inACID);
1185: delete from zpb_excp_explanations ex
1186: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
1187: where analysis_cycle_id = inACID);
1188: else
1189:
1190: for v_instance in c_instances loop

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

1189:
1190: for v_instance in c_instances loop
1191: thisInst := v_instance.instance_ac_id;
1192: delete from zpb_excp_results re
1193: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1194: where analysis_cycle_id = thisInst);
1195: delete from zpb_excp_explanations ex
1196: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
1197: where analysis_cycle_id = thisInst);

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

1192: delete from zpb_excp_results re
1193: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1194: where analysis_cycle_id = thisInst);
1195: delete from zpb_excp_explanations ex
1196: where ex.task_id in (select pd.task_id from zpb_process_details_v pd
1197: where analysis_cycle_id = thisInst);
1198: end loop;
1199:
1200: end if;

Line 3147: from ZPB_PROCESS_DETAILS_V d

3143: v.validate_status = 'VALID' and
3144: v.analysis_cycle_id in (select pa.analysis_cycle_id
3145: from zpb_ac_param_values pa
3146: where pa.param_id = 20 and pa.value in (select d.value
3147: from ZPB_PROCESS_DETAILS_V d
3148: where d.name = 'CREATE_EVENT_IDENTIFIER' and d.task_id = TaskID));
3149:
3150: v_eventACID c_eventACID%ROWTYPE;
3151: