DBA Data[Home] [Help]

APPS.WFA_HTML_UTIL dependencies on WF_MESSAGE_ATTRIBUTES

Line 519: WF_MESSAGE_ATTRIBUTES MA,

515: begin
516: select count(1),max(NA.TEXT_VALUE)
517: into urlcnt, urlstrg
518: from WF_NOTIFICATION_ATTRIBUTES NA,
519: WF_MESSAGE_ATTRIBUTES MA,
520: WF_NOTIFICATIONS N
521: where N.NOTIFICATION_ID = nid
522: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
523: and MA.MESSAGE_NAME = N.MESSAGE_NAME

Line 553: WF_MESSAGE_ATTRIBUTES_VL MA,

549: begin
550: select text_value
551: into buf
552: from WF_NOTIFICATION_ATTRIBUTES NA,
553: WF_MESSAGE_ATTRIBUTES_VL MA,
554: WF_NOTIFICATIONS N
555: where N.NOTIFICATION_ID = nid
556: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
557: and MA.MESSAGE_NAME = N.MESSAGE_NAME