DBA Data[Home] [Help]

APPS.AML_MONITOR_WF dependencies on WF_ITEMS

Line 151: FROM wf_items

147:
148:
149: CURSOR c_get_existing_wf (c_item_type varchar2, c_item_key_like varchar2) is
150: SELECT item_key
151: FROM wf_items
152: WHERE item_type= c_item_type
153: AND item_key like c_item_key_like
154: AND end_date is null
155: ORDER BY item_key desc;

Line 160: from wf_items

156:
157:
158: cursor c_chk_item_key (c_itemtype varchar2,c_itemkey_like varchar2) is
159: select item_key
160: from wf_items
161: where item_type= c_itemtype
162: AND item_key like c_itemkey_like
163: ORDER BY to_number (substr(item_key,(instr(item_key,'_')+1) ) ) desc;
164: