DBA Data[Home] [Help]

APPS.FND_WF_ENGINE dependencies on WF_NOTIFICATIONS

Line 1078: WF_NOTIFICATIONS WN,

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
1082: and WIAS.PROCESS_ACTIVITY = c_instid

Line 1094: WF_NOTIFICATIONS WN,

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
1098: and WIAS.PROCESS_ACTIVITY = c_instid