APPS.WF_PLUG dependencies on WF_ITEM_TYPES_VL

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'