APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_SPARES_OPTIONS

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

511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');
512: END IF;
513:
514: /* Step 10 - Delete Resource Results */
515: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS CRSO
516: WHERE
517: RESOURCE_RESULT_ID IN (SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
518: CSACTL.RESOURCE_RESULT_ID FROM CSF_R_SPARES_OPTIONS
519: CSACTL , CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS

Line 518: CSACTL.RESOURCE_RESULT_ID FROM CSF_R_SPARES_OPTIONS

514: /* Step 10 - Delete Resource Results */
515: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS CRSO
516: WHERE
517: RESOURCE_RESULT_ID IN (SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
518: CSACTL.RESOURCE_RESULT_ID FROM CSF_R_SPARES_OPTIONS
519: CSACTL , CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS
520: CSACC, JTF_TASKS_B TSKT ,JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
521: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
522: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID