APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_RESOURCE_RESULTS

Line 519: CSACTL , CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS

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
523: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =

Line 528: DELETE /*+ index(crrr) */ FROM CSF_R_RESOURCE_RESULTS CRRR

524: CSACC.TASK_ID AND CSACC.REQUEST_TASK_ID=CSRR.REQUEST_TASK_ID
525: AND CSRR.RESOURCE_RESULT_ID =CSACTL.RESOURCE_RESULT_ID);
526:
527:
528: DELETE /*+ index(crrr) */ FROM CSF_R_RESOURCE_RESULTS CRRR
529: WHERE
530: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
531: CSACC.REQUEST_TASK_ID FROM CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS
532: CSACC , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

Line 531: CSACC.REQUEST_TASK_ID FROM CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS

527:
528: DELETE /*+ index(crrr) */ FROM CSF_R_RESOURCE_RESULTS CRRR
529: WHERE
530: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
531: CSACC.REQUEST_TASK_ID FROM CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS
532: CSACC , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
533: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
534: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
535: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = CSACC.TASK_ID AND