APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_PLAN_OPTIONS

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

522: END IF;
523:
524:
525: /* Step 9 - Delete Plan Options */
526: DELETE /*+ index(crpo) */ FROM CSF_R_PLAN_OPTIONS crpo
527: WHERE
528: plan_option_id in
529: (
530: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 533: CSF_R_PLAN_OPTIONS csactl

529: (
530: SELECT /*+ no_unnest no_semijoin cardinality(10) */
531: csactl.plan_option_id
532: FROM
533: CSF_R_PLAN_OPTIONS csactl
534: , CSF_R_PLAN_OPTION_TASKS csacc
535: , JTF_TASKS_B tskt
536: , JTF_OBJECT_PURGE_PARAM_TMP tmp
537: WHERE