APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_PLAN_OPTIONS

Line 489: DELETE /*+ index(crpo) */ FROM CSF_R_PLAN_OPTIONS CRPO

485: END IF;
486:
487:
488: /* Step 9 - Delete Plan Options */
489: DELETE /*+ index(crpo) */ FROM CSF_R_PLAN_OPTIONS CRPO
490: WHERE
491: PLAN_OPTION_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
492: CSACTL.PLAN_OPTION_ID FROM CSF_R_PLAN_OPTIONS
493: CSACTL , CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,

Line 492: CSACTL.PLAN_OPTION_ID FROM CSF_R_PLAN_OPTIONS

488: /* Step 9 - Delete Plan Options */
489: DELETE /*+ index(crpo) */ FROM CSF_R_PLAN_OPTIONS CRPO
490: WHERE
491: PLAN_OPTION_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
492: CSACTL.PLAN_OPTION_ID FROM CSF_R_PLAN_OPTIONS
493: CSACTL , CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,
494: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
495: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
496: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =