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