DBA Data[Home] [Help]

APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 423: from wf_item_attribute_values wiav

419: p_app_bb_id IN NUMBER
420: )
421: IS
422: select wiav.item_key
423: from wf_item_attribute_values wiav
424: where wiav.item_type = 'HXCEMP'
425: and wiav.name = 'APP_BB_ID'
426: and wiav.NUMBER_VALUE = p_app_bb_id;
427:

Line 1937: from wf_item_attribute_values

1933: is
1934:
1935: cursor c_item_attribute_values(p_item_key in varchar2) is
1936: select name,text_value
1937: from wf_item_attribute_values
1938: where item_type = 'HXCEMP'
1939: and item_key = p_item_key;
1940:
1941: l_proc constant varchar2(61) := g_pkg || '.' || 'person_approval';

Line 2315: from wf_item_attribute_values

2311:
2312: cursor get_result
2313: is
2314: select text_value
2315: from wf_item_attribute_values
2316: where item_type = p_itemtype
2317: and item_key = p_itemkey
2318: and name = 'RESULT';
2319: