APPS.WFA_HTML dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

574: -- of another.
575: cursor notification_attrs_cursor(nid number) is
576: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
577: WNA.TEXT_VALUE
578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
579: WF_MESSAGE_ATTRIBUTES_VL WMA
580: where WNA.NOTIFICATION_ID = nid
581: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
582: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

591: -- similar to the above except FORMS do not set ATTACH to Y
592: cursor ntf_forms_attrs_cursor(nid number) is
593: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
594: WNA.TEXT_VALUE
595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
596: WF_MESSAGE_ATTRIBUTES_VL WMA
597: where WNA.NOTIFICATION_ID = nid
598: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
599: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1102: from WF_NOTIFICATION_ATTRIBUTES NA,

1098: NA.NUMBER_VALUE,
1099: NA.DATE_VALUE,
1100: MA.TYPE,
1101: MA.FORMAT
1102: from WF_NOTIFICATION_ATTRIBUTES NA,
1103: WF_MESSAGE_ATTRIBUTES_VL MA,
1104: WF_NOTIFICATIONS N
1105: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1106: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1124: from WF_NOTIFICATION_ATTRIBUTES NA,

1120: MA.DESCRIPTION,
1121: -- remove quotes for onmouse over java func
1122: replace(MA.DESCRIPTION,'''') description2,
1123: NA.TEXT_VALUE
1124: from WF_NOTIFICATION_ATTRIBUTES NA,
1125: WF_MESSAGE_ATTRIBUTES_VL MA,
1126: WF_NOTIFICATIONS N
1127: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1128: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1794: from WF_NOTIFICATION_ATTRIBUTES NA,

1790: MA.DESCRIPTION,
1791: MA.TYPE,
1792: MA.FORMAT
1793: into dispname, description, attrtype, format
1794: from WF_NOTIFICATION_ATTRIBUTES NA,
1795: WF_MESSAGE_ATTRIBUTES_VL MA,
1796: WF_NOTIFICATIONS N
1797: where N.NOTIFICATION_ID = to_number(AttributeInfo.nid)
1798: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1925: from WF_NOTIFICATION_ATTRIBUTES NA,

1921:
1922: -- Count of all response fields
1923: select count(1)
1924: into respcnt
1925: from WF_NOTIFICATION_ATTRIBUTES NA,
1926: WF_MESSAGE_ATTRIBUTES MA,
1927: WF_NOTIFICATIONS N
1928: where N.NOTIFICATION_ID = nid
1929: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1940: from WF_NOTIFICATION_ATTRIBUTES NA,

1936:
1937: -- Count of multiline response fields
1938: select count(1)
1939: into longcnt
1940: from WF_NOTIFICATION_ATTRIBUTES NA,
1941: WF_MESSAGE_ATTRIBUTES MA,
1942: WF_NOTIFICATIONS N
1943: where N.NOTIFICATION_ID = nid
1944: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID