DBA Data[Home] [Help]

APPS.WF_FWKMON dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 25: FROM wf_notification_attributes na,

21: 'DATE', to_char(na.date_value,
22: nvl(ma.format, 'DD/MON/YYYY HH24:MI:SS')),
23: 'LOOKUP', wf_core.activity_result(ma.format, na.text_value),
24: na.text_value) result
25: FROM wf_notification_attributes na,
26: wf_message_attributes_vl ma,
27: wf_notifications n
28: WHERE n.notification_id = x_notificationId
29: AND n.message_type = ma.message_type

Line 66: wf_notification_attributes wna,

62:
63: SELECT 1
64: INTO resp_exists
65: FROM wf_notifications wn,
66: wf_notification_attributes wna,
67: wf_message_attributes m
68: WHERE wn.notification_id = x_notificationId
69: AND wn.notification_id = wna.notification_id
70: AND wn.message_name = m.message_name