[Home] [Help]
272: DELETE /*+ index(jnc) */ FROM JTF_NOTE_CONTEXTS JNC
273: WHERE
274: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
275: JTFNL.JTF_NOTE_ID FROM JTF_NOTE_CONTEXTS JTFNL ,
276: JTF_NOTES_B JTFNB , CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA ,
277: JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
278: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
279: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
280: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = TSKA.TASK_ID AND
286:
287: DELETE /*+ index(jnt)*/ FROM JTF_NOTES_TL JNT
288: WHERE
289: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
290: JTFNB.JTF_NOTE_ID FROM JTF_NOTES_B JTFNB ,
291: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
292: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
293: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
294: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
296: DBFH.DEBRIEF_HEADER_ID = JTFNB.SOURCE_OBJECT_ID AND
297: JTFNB.SOURCE_OBJECT_CODE = 'SD' );
298:
299:
300: DELETE /*+ index(jnb)*/ FROM JTF_NOTES_B JNB
301: WHERE
302: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
303: JTFNB.JTF_NOTE_ID FROM JTF_NOTES_B JTFNB ,
304: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
299:
300: DELETE /*+ index(jnb)*/ FROM JTF_NOTES_B JNB
301: WHERE
302: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
303: JTFNB.JTF_NOTE_ID FROM JTF_NOTES_B JTFNB ,
304: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
305: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
306: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
307: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =