APPS.WF_FWKMON dependencies on WF_NOTIFICATIONS

Line 27: wf_notifications n

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
30: AND n.message_name = ma.message_name
31: AND ma.name = na.name

Line 65: FROM wf_notifications wn,

61: -- single row existence here. 13-NOV-01
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

Line 536: l_responder wf_notifications.responder%type;

532: --
533: function GetNtfResponderName(p_notification_id in number)
534: return varchar2
535: is
536: l_responder wf_notifications.responder%type;
537: l_username varchar2(360);
538: begin
539:
540: SELECT responder

Line 542: FROM wf_notifications

538: begin
539:
540: SELECT responder
541: INTO l_responder
542: FROM wf_notifications
543: WHERE notification_id = p_notification_id;
544:
545: -- Check if directory service has display name
546: l_username := wf_directory.GetRoleDisplayName2(l_responder);

Line 556: FROM wf_notifications wn,

552: -- If the responder was purged from directory service, check for the
553: -- denormalized value from wf_comments table
554: SELECT wc.from_user
555: INTO l_username
556: FROM wf_notifications wn,
557: wf_comments wc
558: WHERE wn.notification_id = p_notification_id
559: AND wn.notification_id = wc.notification_id
560: AND wn.responder = wc.from_role