Line 909: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
905:
906: begin
907: select INSTANCE_ID
908: into rootid 909: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A 910: where A.ITEM_TYPE = itemtype
911: and A.NAME = 'ROOT'
912: and actdate >= A.BEGIN_DATE
913: and actdate < NVL(A.END_DATE, actdate+1)