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 1796: from wf_item_attribute_values

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';

Line 2174: from wf_item_attribute_values

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: