DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_WF_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 270: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

266: -- Changed the query in the cursor for the bug 4696149.
267: /*
268: CURSOR c_notification_id(p_item_key varchar2,p_item_type varchar2) is
269: select Notification_id
270: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
271: where WIAS.ITEM_TYPE = p_item_type
272: and WIAS.ITEM_KEY = p_item_key
273: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
274: and WPA.ACTIVITY_NAME = 'FYI_NOTIFICATION'

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: