DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on WF_NOTIFICATIONS

Line 1471: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn

1467: notificationID number (15);
1468:
1469: cursor getNotificationID is
1470: select wias.notification_id
1471: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn
1472: where wpa.PROCESS_ITEM_TYPE = p_itemtype
1473: and wpa.ACTIVITY_ITEM_TYPE = wpa.PROCESS_ITEM_TYPE
1474: and (wpa.INSTANCE_LABEL = 'NTF_APPROVAL_USERTYPE_REQUIRED'
1475: or wpa.INSTANCE_LABEL = 'NTF_REMIND_USERTYPE_REQUIRED'