DBA Data[Home] [Help]

APPS.JTF_UM_WF_APPROVAL dependencies on WF_NOTIFICATIONS

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

1455: notificationID number (15);
1456:
1457: cursor getNotificationID is
1458: select wias.notification_id
1459: from wf_process_activities wpa, wf_item_activity_statuses wias, wf_notifications wn
1460: where wpa.PROCESS_ITEM_TYPE = p_itemtype
1461: and wpa.ACTIVITY_ITEM_TYPE = wpa.PROCESS_ITEM_TYPE
1462: and (wpa.INSTANCE_LABEL = 'NTF_APPROVAL_USERTYPE_REQUIRED'
1463: or wpa.INSTANCE_LABEL = 'NTF_REMIND_USERTYPE_REQUIRED'