APPS.PON_AWARD_APPROVAL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES
Line 2356: FROM wf_item_activity_statuses
2352: -- try to obtain the id of the notification to which the user is responding to
2353: BEGIN
2354: SELECT notification_id
2355: INTO l_notification_id 2356: FROM wf_item_activity_statuses 2357: WHERE
2358: assigned_user = p_user_name
2359: AND item_type = AWARD_APPROVAL_WF_ITEM_TYPE
2360: AND item_key = l_item_key