APPS.WF_QUEUE dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 839: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,

835: -- check begin date as well
836: -- move the BEGIN_DATE, SYSDATE comparion to a separate clause
837: SELECT CWA.COST, CWIAS.BEGIN_DATE
838: into cost, l_begdate
839: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
840: WF_PROCESS_ACTIVITIES CWPA,
841: WF_ITEMS WI,
842: WF_ACTIVITIES CWA
843: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'

Line 942: from wf_item_activity_statuses_h

938: (g_ActivityHistoryCount(g_Key).ACTID <> enqueue_event.actid)) then
939:
940: select count(process_activity)
941: into l_background_occurrence
942: from wf_item_activity_statuses_h
943: where item_type = enqueue_event.itemtype
944: and item_key = enqueue_event.itemkey
945: and process_activity = enqueue_event.actid
946: and begin_date >= g_background_begin_date;