APPS.CSF_MAINTAIN_GRP dependencies on CSF_DEBRIEF_LINES

Line 317: 1) CSF_DEBRIEF_LINES

313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
314: END IF;
315:
316: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
317: 1) CSF_DEBRIEF_LINES
318: */
319:
320: DELETE /*+ index (cdl)*/
321: FROM CSF_DEBRIEF_LINES CDL

Line 321: FROM CSF_DEBRIEF_LINES CDL

317: 1) CSF_DEBRIEF_LINES
318: */
319:
320: DELETE /*+ index (cdl)*/
321: FROM CSF_DEBRIEF_LINES CDL
322: WHERE DEBRIEF_LINE_ID IN
323: ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10)*/
324: DBFL.DEBRIEF_LINE_ID
325: FROM CSF_DEBRIEF_LINES DBFL ,

Line 325: FROM CSF_DEBRIEF_LINES DBFL ,

321: FROM CSF_DEBRIEF_LINES CDL
322: WHERE DEBRIEF_LINE_ID IN
323: ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10)*/
324: DBFL.DEBRIEF_LINE_ID
325: FROM CSF_DEBRIEF_LINES DBFL ,
326: CSF_DEBRIEF_HEADERS DBFH ,
327: JTF_TASK_ASSIGNMENTS TSKA ,
328: JTF_TASKS_B TSKT ,
329: JTF_OBJECT_PURGE_PARAM_TMP TMP