APPS.CS_INCIDENTLINKS_PVT dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 2642: -- an SR present in the global temp table jtf_object_purge_param_tmp with

2638: );
2639: END IF ;
2640:
2641: -- The following statement deletes all the links that are related to
2642: -- an SR present in the global temp table jtf_object_purge_param_tmp with
2643: -- purge_status NULL, indicating that the SR is available for purge.
2644:
2645: DELETE /*+ index(l) */ cs_incident_links l
2646: WHERE

Line 2652: jtf_object_purge_param_tmp t

2648: (
2649: SELECT /*+ unnest no_semijoin leading(t) use_concat cardinality(10) */
2650: l.link_id
2651: FROM
2652: jtf_object_purge_param_tmp t
2653: , cs_incident_links l
2654: WHERE
2655: NVL(t.purge_status, 'S') = 'S'
2656: AND t.processing_set_id = p_processing_set_id