APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_PLAN_OPTION_TASKS

Line 534: , CSF_R_PLAN_OPTION_TASKS csacc

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
538: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 547: DELETE /*+ index(crpot) */ FROM CSF_R_PLAN_OPTION_TASKS crpot

543: csacc.plan_option_id = csactl.plan_option_id
544: );
545:
546:
547: DELETE /*+ index(crpot) */ FROM CSF_R_PLAN_OPTION_TASKS crpot
548: WHERE
549: task_id in
550: (
551: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 554: CSF_R_PLAN_OPTION_TASKS csacc

550: (
551: SELECT /*+ no_unnest no_semijoin cardinality(10) */
552: csacc.task_id
553: FROM
554: CSF_R_PLAN_OPTION_TASKS csacc
555: , JTF_TASKS_B tskt
556: , JTF_OBJECT_PURGE_PARAM_TMP tmp
557: WHERE
558: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and