DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on WF_NOTIFICATIONS

Line 280: from WF_NOTIFICATIONS WN, WF_ITEM_ACTIVITY_STATUSES WIAS

276: */
277:
278: CURSOR c_notification_id(p_item_key varchar2,p_item_type varchar2) is
279: select wn.notification_id nid
280: from WF_NOTIFICATIONS WN, WF_ITEM_ACTIVITY_STATUSES WIAS
281: where WN.GROUP_ID = WIAS.NOTIFICATION_ID
282: and WIAS.ITEM_TYPE = p_item_type
283: and WIAS.ITEM_KEY = p_item_key;
284: