DBA Data[Home] [Help]

APPS.WFA_HTML dependencies on WF_MESSAGE_ATTRIBUTES

Line 612: from WF_MESSAGE_ATTRIBUTES MA,

608:
609: -- Count of multiline response fields
610: select count(1)
611: into urlcnt
612: from WF_MESSAGE_ATTRIBUTES MA,
613: WF_NOTIFICATIONS N
614: where N.NOTIFICATION_ID = nid
615: and MA.MESSAGE_NAME = N.MESSAGE_NAME
616: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 628: WF_MESSAGE_ATTRIBUTES MA,

624: -- Count of all response fields
625: select count(1)
626: into respcnt
627: from WF_NOTIFICATION_ATTRIBUTES NA,
628: WF_MESSAGE_ATTRIBUTES MA,
629: WF_NOTIFICATIONS N
630: where N.NOTIFICATION_ID = nid
631: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
632: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 643: WF_MESSAGE_ATTRIBUTES MA,

639: -- Count of multiline response fields
640: select count(1)
641: into longcnt
642: from WF_NOTIFICATION_ATTRIBUTES NA,
643: WF_MESSAGE_ATTRIBUTES MA,
644: WF_NOTIFICATIONS N
645: where N.NOTIFICATION_ID = nid
646: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
647: and MA.MESSAGE_NAME = N.MESSAGE_NAME