APPS.WF_REPOPULATE_AQ dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 26: from WF_ITEM_ACTIVITY_STATUSES IAS, WF_NOTIFICATIONS N

22: PRAGMA AUTONOMOUS_TRANSACTION;
23:
24: Cursor CN IS
25: Select N.NOTIFICATION_ID
26: from WF_ITEM_ACTIVITY_STATUSES IAS, WF_NOTIFICATIONS N
27: where IAS.Item_Type = x_Item_Type
28: and IAS.Item_Key = x_Item_Key
29: and IAS.NOTIFICATION_ID = N.GROUP_ID
30: and N.status = 'OPEN'

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