DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 1555: from wf_item_activity_statuses_h ias

1551: where ias.item_type = itemType
1552: and ias.item_key = itemKey
1553: union all
1554: select notification_id
1555: from wf_item_activity_statuses_h ias
1556: where ias.item_type = itemType
1557: and ias.item_key = itemKey) intf, wf_notifications ntf
1558: where intf.notification_id = ntf.group_id)
1559: where role <> current_role