DBA Data[Home] [Help]

APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 132: WF_ITEM_ATTRIBUTE_VALUES attrib

128: WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE
129: FROM WF_ITEMS WorkflowItemEO,
130: WF_ITEM_TYPES_VL WorkflowItemTypeEO,
131: WF_ACTIVITIES_VL ActivityEO,
132: WF_ITEM_ATTRIBUTE_VALUES attrib
133: WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME
134: AND ActivityEO.ITEM_TYPE = WorkflowItemEO.ITEM_TYPE
135: AND ActivityEO.NAME = WorkflowItemEO.ROOT_ACTIVITY
136: AND ActivityEO.VERSION = WorkflowItemEO.ROOT_ACTIVITY_VERSION

Line 154: From WF_ITEMS item, WF_ITEM_ATTRIBUTE_VALUES attr

150: Function getMaxNoActiveReqs return pls_integer is
151: l_no pls_integer := 0;
152: l_max_no varchar2(4000) := null;
153: cursor MaxNoRequest is SELECT attr.text_value into l_max_no
154: From WF_ITEMS item, WF_ITEM_ATTRIBUTE_VALUES attr
155: Where
156: item.item_type = attr.item_type
157: And
158: item.item_key = attr.item_key