APPS.CSF_MAINTAIN_GRP dependencies on JTF_NOTE_CONTEXTS

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

249: */
250:
251:
252: /* Step 1 - Delete relevant debrief notes and note contexts */
253: DELETE /*+ index(jnc) */ FROM JTF_NOTE_CONTEXTS jnc
254: WHERE
255: jtf_note_id in
256: (
257: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 260: JTF_NOTE_CONTEXTS jtfnl

256: (
257: SELECT /*+ no_unnest no_semijoin cardinality(10) */
258: jtfnl.jtf_note_id
259: FROM
260: JTF_NOTE_CONTEXTS jtfnl
261: , JTF_NOTES_B jtfnb
262: , CSF_DEBRIEF_HEADERS dbfh
263: , JTF_TASK_ASSIGNMENTS tska
264: , JTF_TASKS_B tskt