APPS.CSF_MAINTAIN_GRP dependencies on JTF_NOTES_B

Line 261: , JTF_NOTES_B jtfnb

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
265: , JTF_OBJECT_PURGE_PARAM_TMP tmp

Line 287: JTF_NOTES_B jtfnb

283: (
284: SELECT /*+ no_unnest no_semijoin cardinality(10) */
285: jtfnb.jtf_note_id
286: FROM
287: JTF_NOTES_B jtfnb
288: , CSF_DEBRIEF_HEADERS dbfh
289: , JTF_TASK_ASSIGNMENTS tska
290: , JTF_TASKS_B tskt
291: , JTF_OBJECT_PURGE_PARAM_TMP tmp

Line 304: DELETE /*+ index(jnb)*/ from JTF_NOTES_B jnb

300: jtfnb.source_object_code = 'DF'
301: );
302:
303:
304: DELETE /*+ index(jnb)*/ from JTF_NOTES_B jnb
305: WHERE
306: jtf_note_id in
307: (
308: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 311: JTF_NOTES_B jtfnb

307: (
308: SELECT /*+ no_unnest no_semijoin cardinality(10) */
309: jtfnb.jtf_note_id
310: FROM
311: JTF_NOTES_B jtfnb
312: , CSF_DEBRIEF_HEADERS dbfh
313: , JTF_TASK_ASSIGNMENTS tska
314: , JTF_TASKS_B tskt
315: , JTF_OBJECT_PURGE_PARAM_TMP tmp