APPS.CSF_MAINTAIN_GRP dependencies on CSF_ACCESS_HOURS_B

Line 453: CSF_ACCESS_HOURS_B csacc

449: SELECT /*+ LEADING(TMP) no_unnest no_semijoin cardinality(TMP,
450: 10) */
451: csacc.access_hour_id
452: FROM
453: CSF_ACCESS_HOURS_B csacc
454: , JTF_TASKS_B tskt
455: , JTF_OBJECT_PURGE_PARAM_TMP tmp
456: WHERE
457: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 464: DELETE /*+ index(cahb) */ FROM CSF_ACCESS_HOURS_B cahb

460: tmp.object_type = tskt.source_object_type_code and
461: tskt.task_id = csacc.task_id
462: );
463:
464: DELETE /*+ index(cahb) */ FROM CSF_ACCESS_HOURS_B cahb
465: WHERE
466: task_id in
467: (
468: SELECT /*+ cardinality(TMP, 10) */

Line 471: CSF_ACCESS_HOURS_B csacc

467: (
468: SELECT /*+ cardinality(TMP, 10) */
469: csacc.task_id
470: FROM
471: CSF_ACCESS_HOURS_B csacc
472: , JTF_TASKS_B tskt
473: , JTF_OBJECT_PURGE_PARAM_TMP tmp
474: WHERE
475: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and