2326: , na.TEXT_VALUE
2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
2334: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8320: AND ntf.NOTIFICATION_ID <> orig_ntf.NOTIFICATION_ID
8321: AND orig_ntf.NOTIFICATION_ID = p_orig_ntf_id
8322: AND EXISTS (SELECT 1
8323: FROM WF_NOTIFICATION_ATTRIBUTES na,
8324: WF_MESSAGE_ATTRIBUTES ma
8325: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
8326: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8327: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
8328: AND ma.NAME = na.NAME
11139: AND wias.ITEM_KEY = p_item_key
11140: AND ntf.RECIPIENT_ROLE = p_responder
11141: AND EXISTS (SELECT 1
11142: FROM WF_NOTIFICATION_ATTRIBUTES na,
11143: WF_MESSAGE_ATTRIBUTES ma
11144: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
11145: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
11146: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
11147: AND ma.NAME = na.NAME