DBA Data[Home] [Help]

APPS.WF_REPOPULATE_AQ dependencies on WF_PROCESS_ACTIVITIES

Line 67: from WF_ITEM_ACTIVITY_STATUSES CWIAS, WF_PROCESS_ACTIVITIES CWPA,

63: CWIAS.ITEM_TYPE,
64: CWIAS.ITEM_KEY,
65: CWIAS.PROCESS_ACTIVITY,
66: greatest((CWIAS.BEGIN_DATE - sysdate)*86400,0) delay
67: from WF_ITEM_ACTIVITY_STATUSES CWIAS, WF_PROCESS_ACTIVITIES CWPA,
68: WF_PROCESS_ACTIVITIES PWPA, WF_ITEM_ACTIVITY_STATUSES PWIAS
69: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'
70: and CWIAS.PROCESS_ACTIVITY = CWPA.INSTANCE_ID
71: and CWPA.ACTIVITY_ITEM_TYPE = x_Item_Type

Line 68: WF_PROCESS_ACTIVITIES PWPA, WF_ITEM_ACTIVITY_STATUSES PWIAS

64: CWIAS.ITEM_KEY,
65: CWIAS.PROCESS_ACTIVITY,
66: greatest((CWIAS.BEGIN_DATE - sysdate)*86400,0) delay
67: from WF_ITEM_ACTIVITY_STATUSES CWIAS, WF_PROCESS_ACTIVITIES CWPA,
68: WF_PROCESS_ACTIVITIES PWPA, WF_ITEM_ACTIVITY_STATUSES PWIAS
69: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'
70: and CWIAS.PROCESS_ACTIVITY = CWPA.INSTANCE_ID
71: and CWPA.ACTIVITY_ITEM_TYPE = x_Item_Type
72: and CWIAS.ITEM_TYPE = x_Item_Type