APPS.CSF_MAINTAIN_GRP dependencies on CSF_DEBRIEF_LINES

Line 332: 1) CSF_DEBRIEF_LINES

328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
329: END IF;
330:
331: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
332: 1) CSF_DEBRIEF_LINES
333: */
334:
335: DELETE /*+ index(cdl) */ FROM CSF_DEBRIEF_LINES cdl
336: WHERE

Line 335: DELETE /*+ index(cdl) */ FROM CSF_DEBRIEF_LINES cdl

331: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
332: 1) CSF_DEBRIEF_LINES
333: */
334:
335: DELETE /*+ index(cdl) */ FROM CSF_DEBRIEF_LINES cdl
336: WHERE
337: debrief_line_id in
338: (
339: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 342: CSF_DEBRIEF_LINES dbfl

338: (
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