APPS.CSF_MAINTAIN_GRP dependencies on CSF_DEBRIEF_HEADERS

Line 262: , CSF_DEBRIEF_HEADERS dbfh

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
266: WHERE

Line 288: , CSF_DEBRIEF_HEADERS dbfh

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
292: WHERE

Line 312: , CSF_DEBRIEF_HEADERS dbfh

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
316: WHERE

Line 343: , CSF_DEBRIEF_HEADERS dbfh

339: SELECT /*+ no_unnest no_semijoin cardinality(10) */
340: dbfl.debrief_line_id
341: FROM
342: CSF_DEBRIEF_LINES dbfl
343: , CSF_DEBRIEF_HEADERS dbfh
344: , JTF_TASK_ASSIGNMENTS tska
345: , JTF_TASKS_B tskt
346: , JTF_OBJECT_PURGE_PARAM_TMP tmp
347: WHERE

Line 363: DELETE /*+ index(cdh) */ FROM CSF_DEBRIEF_HEADERS cdh

359: END IF;
360:
361:
362: /* Step 3 - Delete relevant debrief headers*/
363: DELETE /*+ index(cdh) */ FROM CSF_DEBRIEF_HEADERS cdh
364: WHERE
365: debrief_header_id in
366: (
367: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 370: CSF_DEBRIEF_HEADERS dbfh

366: (
367: SELECT /*+ no_unnest no_semijoin cardinality(10) */
368: dbfh.debrief_header_id
369: FROM
370: CSF_DEBRIEF_HEADERS dbfh
371: , JTF_TASK_ASSIGNMENTS tska
372: , JTF_TASKS_B tskt
373: , JTF_OBJECT_PURGE_PARAM_TMP tmp
374: WHERE