APPS.CSF_MAINTAIN_GRP dependencies on JTF_NOTES_TL

Line 287: DELETE /*+ index(jnt)*/ FROM JTF_NOTES_TL JNT

283: JTFNB.SOURCE_OBJECT_CODE = 'SD' AND JTFNB.JTF_NOTE_ID = JTFNL.JTF_NOTE_ID );
284:
285:
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 ,