APPS.AML_MONITOR_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 166: SELECT text_value from wf_item_attribute_values

162: AND item_key like c_itemkey_like
163: ORDER BY to_number (substr(item_key,(instr(item_key,'_')+1) ) ) desc;
164:
165: CURSOR c_prev_monitor_type (c_item_type varchar2, c_item_key varchar2) is
166: SELECT text_value from wf_item_attribute_values
167: WHERE item_type = c_item_type
168: AND item_key like c_item_key
169: AND name = 'TIMELAG_FROM_STAGE'
170: -- swkhanna 9/8/03

Line 177: SELECT number_value from wf_item_attribute_values

173:
174:
175:
176: CURSOR c_monitor_values (c_item_type varchar2, c_item_key varchar2, c_attr_name varchar2) is
177: SELECT number_value from wf_item_attribute_values
178: WHERE item_type = c_item_type
179: AND item_key = c_item_key
180: AND name = c_attr_name
181: ORDER BY item_key desc;