DBA Data[Home] [Help]

APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_LOOKUPS

Line 726: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL

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
730: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 754: WF_MESSAGE_ATTRIBUTES_VL WMA , WF_LOOKUPS WL

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
758: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE