APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_MESSAGE_TOKENS

Line 552: DELETE /*+ index(crmt) */ FROM CSF_R_MESSAGE_TOKENS CRMT

548: END IF;
549:
550: /* Step 11 - Delete Messages and Message Tokens */
551: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
552: DELETE /*+ index(crmt) */ FROM CSF_R_MESSAGE_TOKENS CRMT
553: WHERE
554: MESSAGE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
555: CSACTL.MESSAGE_ID FROM CSF_R_MESSAGE_TOKENS CSACTL ,
556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR

Line 555: CSACTL.MESSAGE_ID FROM CSF_R_MESSAGE_TOKENS CSACTL ,

551: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
552: DELETE /*+ index(crmt) */ FROM CSF_R_MESSAGE_TOKENS CRMT
553: WHERE
554: MESSAGE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
555: CSACTL.MESSAGE_ID FROM CSF_R_MESSAGE_TOKENS CSACTL ,
556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
557: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
558: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
559: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND