APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_MESSAGES

Line 669: , CSF_R_MESSAGES csacc

665: SELECT /*+ no_unnest no_semijoin cardinality(10) */
666: csactl.MESSAGE_ID
667: FROM
668: CSF_R_MESSAGE_TOKENS csactl
669: , CSF_R_MESSAGES csacc
670: , JTF_TASKS_B tskt
671: , JTF_OBJECT_PURGE_PARAM_TMP tmp
672: WHERE
673: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 682: DELETE /*+ index(crm) */ FROM CSF_R_MESSAGES crm

678: csacc.MESSAGE_ID = csactl.MESSAGE_ID
679: );
680:
681:
682: DELETE /*+ index(crm) */ FROM CSF_R_MESSAGES crm
683: WHERE
684: REQUEST_TASK_ID in
685: (
686: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 689: CSF_R_MESSAGES csacc

685: (
686: SELECT /*+ no_unnest no_semijoin cardinality(10) */
687: csacc.REQUEST_TASK_ID
688: FROM
689: CSF_R_MESSAGES csacc
690: , JTF_TASKS_B tskt
691: , JTF_OBJECT_PURGE_PARAM_TMP tmp
692: WHERE
693: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and