[Home] [Help]
1225: , cs_incidents_all_b i
1226: , ( select /*+ no_merge parallel(a) */
1227: distinct task_id
1228: from
1229: jtf_task_audits_b a
1230: where
1231: new_source_object_type_code = 'SR'
1232: and creation_date >= l_collect_from_date
1233: ) a