APPS.CSF_MAINTAIN_GRP dependencies on CSF_REQUIRED_SKILLS_B

Line 430: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B CRSB

426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
427: END IF;
428:
429: /* Step 7 - Delete relevant required skills */
430: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B CRSB
431: WHERE
432: REQUIRED_SKILL_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
433: CSFSK.REQUIRED_SKILL_ID FROM CSF_REQUIRED_SKILLS_B
434: CSFSK , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

Line 433: CSFSK.REQUIRED_SKILL_ID FROM CSF_REQUIRED_SKILLS_B

429: /* Step 7 - Delete relevant required skills */
430: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B CRSB
431: WHERE
432: REQUIRED_SKILL_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
433: CSFSK.REQUIRED_SKILL_ID FROM CSF_REQUIRED_SKILLS_B
434: CSFSK , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
435: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
436: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
437: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = CSFSK.HAS_SKILL_ID AND