APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_NOTIFICATIONS

Line 725: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

721:
722:
723: CURSOR GET_RESPONSE_ATTR IS
724: select WMA.NAME,WMA.DISPLAY_NAME, WL.meaning
725: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
726: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL
727: where WNA.NOTIFICATION_ID = wf_engine.context_nid
728: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
729: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 740: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

736: and decode(wma.name,'RESULT','RESULT','NORESULT') = 'NORESULT'
737: union
738: select WMA.NAME,WMA.DISPLAY_NAME, decode(wma.type,'VARCHAR2',wna.text_value,'NUMBER',
739: to_char(wna.number_value),'DATE',to_char(wna.date_value))
740: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
741: WF_MESSAGE_ATTRIBUTES_VL WMA
742: where WNA.NOTIFICATION_ID = wf_engine.context_nid
743: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
744: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 753: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

749: and decode(wma.name,'RESULT','RESULT','NORESULT') = 'NORESULT';
750:
751: CURSOR GET_USER_RESPONSE_RESULT IS
752: select WL.LOOKUP_CODE,WMA.DISPLAY_NAME, WL.meaning
753: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
754: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL
755: where WNA.NOTIFICATION_ID = wf_engine.context_nid
756: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID
757: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME