DBA Data[Home] [Help]

APPS.WF_ENGINE_BULK dependencies on WF_PROCESS_ACTIVITIES

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)

Line 1110: FROM WF_PROCESS_ACTIVITIES WPA

1106: SELECT PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION,
1107: ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, INSTANCE_ID,
1108: INSTANCE_LABEL, PERFORM_ROLE, PERFORM_ROLE_TYPE,
1109: START_END, DEFAULT_RESULT
1110: FROM WF_PROCESS_ACTIVITIES WPA
1111: WHERE WPA.PROCESS_ITEM_TYPE = itemtype
1112: AND WPA.PROCESS_NAME = process
1113: AND WPA.PROCESS_VERSION = version
1114: AND WPA.START_END = wf_engine.eng_start

Line 1727: FROM WF_PROCESS_ACTIVITIES WPA

1723: begin
1724:
1725: SELECT WPA.INSTANCE_ID
1726: into actid
1727: FROM WF_PROCESS_ACTIVITIES WPA
1728: WHERE WPA.PROCESS_ITEM_TYPE = itemtype
1729: AND WPA.PROCESS_NAME = process
1730: AND WPA.PROCESS_VERSION = version
1731: AND WPA.START_END = wf_engine.eng_start