Line 946: (select item_key,item_type from wf_items);/*Bug 9276888 Delete those records from
942: delete from pa_wf_processes where
943: entity_key1 = TO_CHAR(x_project_id)
944: and item_type <> 'PABUDWF'
945: and (item_key,item_type) not in 946: (select item_key,item_type from wf_items);/*Bug 9276888 Delete those records from 947: pa_wf_processes for which WF Purge has been run. */
948:
949: FOR i IN ( SELECT item_type,item_key
950: FROM pa_wf_processes