APPS.CSF_MAINTAIN_GRP dependencies on CSF_ACCESS_HOURS_B

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

479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');
480: END IF;
481:
482: /* Step 8 - Delete Access Hours */
483: DELETE /*+ index(cahb) */ FROM CSF_ACCESS_HOURS_B cahb
484: WHERE
485: task_id in
486: (
487: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 490: CSF_ACCESS_HOURS_B csacc

486: (
487: SELECT /*+ no_unnest no_semijoin cardinality(10) */
488: csacc.task_id
489: FROM
490: CSF_ACCESS_HOURS_B csacc
491: , JTF_TASKS_B tskt
492: , JTF_OBJECT_PURGE_PARAM_TMP tmp
493: WHERE
494: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 509: CSF_ACCESS_HOURS_B csacc

505: (
506: SELECT /*+ no_unnest no_semijoin cardinality(10) */
507: csacc.access_hour_id
508: FROM
509: CSF_ACCESS_HOURS_B csacc
510: , JTF_TASKS_B tskt
511: , JTF_OBJECT_PURGE_PARAM_TMP tmp
512: WHERE
513: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and