APPS.WF_ITEM_ACTIVITY_STATUS dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 551: -- the history table. If record exists in WF_ITEM_ACTIVITY_STATUSES_H,

547: end if;
548:
549: -- Bug 3960517
550: -- No record was found in WF_ITEM_ACTIVITY_STATUSES. We will check
551: -- the history table. If record exists in WF_ITEM_ACTIVITY_STATUSES_H,
552: -- we may have re-entered a node causing engine to prepare for looping.
553: -- But instead of going through all the activities along the loop, it has
554: -- progressed through a different path. Since there maybe multiple records
555: -- in the history table with the same item type, item key and actid, we may

Line 559: from WF_ITEM_ACTIVITY_STATUSES_H

555: -- in the history table with the same item type, item key and actid, we may
556: -- not be able to mark the error accordingly, so we just simply ignore the error.
557: if (SQL%NOTFOUND) then
558: select 1 into l_exist
559: from WF_ITEM_ACTIVITY_STATUSES_H
560: where ITEM_TYPE = itemtype
561: and ITEM_KEY= itemkey
562: and process_activity = actid
563: and rownum < 2;