APPS.POS_REG_WF_PKG dependencies on WF_NOTIFICATIONS

Line 3335: FROM wf_item_activity_statuses_v ws, wf_notifications wn

3331: IF ( funcmode = 'RUN' ) then
3332:
3333: SELECT DECODE(wn.mail_status, 'MAIL', 'COMPLETE:N', 'COMPLETE:Y')
3334: INTO resultout
3335: FROM wf_item_activity_statuses_v ws, wf_notifications wn
3336: WHERE ws.item_type = itemtype
3337: AND ws.item_key = itemkey
3338: AND ws.notification_id = wn.notification_id;
3339: