APPS.CSF_MAINTAIN_GRP dependencies on JTF_NOTE_CONTEXTS

Line 272: DELETE /*+ index(jnc) */ FROM JTF_NOTE_CONTEXTS JNC

268: */
269:
270:
271: /* Step 1 - Delete relevant debrief notes and note contexts */
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 ,

Line 275: JTFNL.JTF_NOTE_ID FROM JTF_NOTE_CONTEXTS JTFNL ,

271: /* Step 1 - Delete relevant debrief notes and note contexts */
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 =