APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_SPARES_OPTIONS

Line 615: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS crso

611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');
612: END IF;
613:
614: /* Step 11 - Delete Resource Results */
615: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS crso
616: WHERE
617: RESOURCE_RESULT_ID in
618: (
619: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 622: CSF_R_SPARES_OPTIONS csactl

618: (
619: SELECT /*+ no_unnest no_semijoin cardinality(10) */
620: csactl.RESOURCE_RESULT_ID
621: FROM
622: CSF_R_SPARES_OPTIONS csactl
623: , CSF_R_RESOURCE_RESULTS csacc
624: , JTF_TASKS_B tskt
625: , JTF_OBJECT_PURGE_PARAM_TMP tmp
626: WHERE