APPS.WF_PLUG dependencies on WF_NOTIFICATIONS

Line 268: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT

264:
265: -- Lookup for Item Type
266: cursor itcurs(role in varchar2) is
267: select unique WIT.DISPLAY_NAME, WN.MESSAGE_TYPE
268: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT
269: where WN.MESSAGE_TYPE = WIT.NAME
270: and WN.RECIPIENT_ROLE = role
271: order by WIT.DISPLAY_NAME;
272:

Line 521: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL

517: WN.END_DATE,
518: WL.MEANING display_status,
519: WN.STATUS,
520: WN.LANGUAGE
521: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
522: where WN.MESSAGE_TYPE = decode(Worklist.littype, '*', WN.MESSAGE_TYPE,
523: Worklist.littype)
524: and WN.MESSAGE_TYPE = WIT.NAME
525: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'

Line 559: WF_NOTIFICATIONS N

555: cursor attrs(mnid in number) is
556: select MA.NAME
557: from WF_NOTIFICATION_ATTRIBUTES NA,
558: WF_MESSAGE_ATTRIBUTES_VL MA,
559: WF_NOTIFICATIONS N
560: where N.NOTIFICATION_ID = mnid
561: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
562: and MA.MESSAGE_NAME = N.MESSAGE_NAME
563: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE