APPS.CSF_MAINTAIN_GRP dependencies on CSF_R_MESSAGES

Line 556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR

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
560: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID AND

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

560: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID AND
561: CSRM.MESSAGE_ID = CSACTL.MESSAGE_ID );
562:
563: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
564: DELETE /*+ index(crm) */ FROM CSF_R_MESSAGES CRM
565: WHERE
566: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
567: CSACC.REQUEST_TASK_ID FROM CSF_R_MESSAGES CSRM ,
568: CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR

Line 567: CSACC.REQUEST_TASK_ID FROM CSF_R_MESSAGES CSRM ,

563: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
564: DELETE /*+ index(crm) */ FROM CSF_R_MESSAGES CRM
565: WHERE
566: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
567: CSACC.REQUEST_TASK_ID FROM CSF_R_MESSAGES CSRM ,
568: CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
569: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
570: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
571: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND