APPS.WF_MONITOR dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 845: wf_notification_attributes na,

841: 'DD-MON-YYYY HH24:MI:SS')),
842: 'LOOKUP', wf_core.activity_result(ma.format, na.text_value),
843: na.text_value) value
844: from wf_notifications n,
845: wf_notification_attributes na,
846: wf_message_attributes_vl ma
847: where n.group_id = nid
848: and n.message_type = ma.message_type
849: and n.message_name = ma.message_name

Line 3043: from WF_NOTIFICATION_ATTRIBUTES NA,

3039: pseudo_login BOOLEAN := FALSE;
3040:
3041: cursor attrs(mnid in number) is
3042: select MA.NAME
3043: from WF_NOTIFICATION_ATTRIBUTES NA,
3044: WF_MESSAGE_ATTRIBUTES_VL MA,
3045: WF_NOTIFICATIONS N
3046: where N.NOTIFICATION_ID = mnid
3047: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 3388: FROM wf_notification_attributes na,

3384: na.text_value) result,
3385: 1
3386: INTO x_notification_result,
3387: x_notification_response
3388: FROM wf_notification_attributes na,
3389: wf_message_attributes_vl ma,
3390: wf_notifications n
3391: WHERE n.group_id = x_notification_id
3392: AND n.message_type = ma.message_type

Line 3424: FROM wf_notification_attributes na,

3420: IF x_notification_result = 'WF_NOTFOUND' THEN
3421: BEGIN
3422: SELECT count(*)
3423: INTO x_notification_response
3424: FROM wf_notification_attributes na,
3425: wf_message_attributes_vl ma,
3426: wf_notifications n
3427: WHERE n.group_id = x_notification_id
3428: AND n.message_type = ma.message_type