APPS.CSF_MAINTAIN_GRP dependencies on CSF_REQUIRED_SKILLS_B

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

455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
456: END IF;
457:
458: /* Step 7 - Delete relevant required skills */
459: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B crsb
460: WHERE
461: required_skill_id in
462: (
463: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 466: CSF_REQUIRED_SKILLS_B csfsk

462: (
463: SELECT /*+ no_unnest no_semijoin cardinality(10) */
464: csfsk.required_skill_id
465: FROM
466: CSF_REQUIRED_SKILLS_B csfsk
467: , JTF_TASKS_B tskt
468: , JTF_OBJECT_PURGE_PARAM_TMP tmp
469: WHERE
470: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and