APPS.FND_WF_ENGINE dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1077: from WF_ITEM_ACTIVITY_STATUSES WIAS,

1073: colon := instr(l_username, ':');
1074: if (colon = 0) then
1075: select count(1)
1076: into disable_or_launch
1077: from WF_ITEM_ACTIVITY_STATUSES WIAS,
1078: WF_NOTIFICATIONS WN,
1079: WF_NOTIFICATION_ATTRIBUTES NATTR
1080: where WIAS.ITEM_TYPE = l_item_type
1081: and WIAS.ITEM_KEY = l_itemkey

Line 1093: from WF_ITEM_ACTIVITY_STATUSES WIAS,

1089: where WUR.USER_NAME = l_username);
1090: else
1091: select count(1)
1092: into disable_or_launch
1093: from WF_ITEM_ACTIVITY_STATUSES WIAS,
1094: WF_NOTIFICATIONS WN,
1095: WF_NOTIFICATION_ATTRIBUTES NATTR
1096: where WIAS.ITEM_TYPE = l_item_type
1097: and WIAS.ITEM_KEY = l_itemkey