DBA Data[Home] [Help]

APPS.CS_MESSAGES_PKG dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 630: -- the global temp table jtf_object_purge_param_tmp which have

626: END IF ;
627:
628: -- The following delete statement deletes the rows in the
629: -- cs_messages table which correspond to the incident_ids in
630: -- the global temp table jtf_object_purge_param_tmp which have
631: -- purge_status NULL indicating that the SR is available for
632: -- purge.
633:
634: DELETE /*+ index(m) */

Line 644: jtf_object_purge_param_tmp

640: (
641: SELECT /*+ no_unnest no_semijoin cardinality(10) */
642: object_id
643: FROM
644: jtf_object_purge_param_tmp
645: WHERE
646: object_type = 'SR'
647: AND p_processing_set_id = processing_set_id
648: AND NVL(purge_status, 'S') = 'S'