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:
1792: is
1793:
1794: cursor c_item_attribute_values(p_item_key in varchar2) is
1795: select name,text_value
1796: from wf_item_attribute_values
1797: where item_type = 'HXCEMP'
1798: and item_key = p_item_key;
1799:
1800: l_proc constant varchar2(61) := g_pkg || '.' || 'person_approval';
2170:
2171: cursor get_result
2172: is
2173: select text_value
2174: from wf_item_attribute_values
2175: where item_type = p_itemtype
2176: and item_key = p_itemkey
2177: and name = 'RESULT';
2178: