DBA Data[Home] [Help]

APPS.INV_CONSIGN_NOTIF_UTL dependencies on WF_NOTIFICATIONS

Line 153: FROM wf_item_activity_statuses_v was, wf_notifications wfn

149:
150: -- get notification_id and last_notification_date
151: SELECT wfn.notification_id, wfn.begin_date
152: INTO x_notification_id, x_notification_date
153: FROM wf_item_activity_statuses_v was, wf_notifications wfn
154: WHERE was.item_type = l_item_type
155: AND was.activity_name = l_activity_name
156: AND was.item_key = l_item_key
157: AND wfn.notification_id = was.notification_id;