APPS.FTE_WF_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

   SELECT activity_status
   INTO l_activity_status
   FROM wf_item_activity_statuses
   WHERE item_type 	= itemtype
   AND item_key		= itemkey
   AND process_activity IN (
   	select INSTANCE_ID
	from   WF_PROCESS_ACTIVITIES
	where  PROCESS_ITEM_TYPE = itemtype
	and    PROCESS_NAME      = p_workflow_process
	and    INSTANCE_LABEL    = p_block_label);

Line: 87

      select NUMBER_VALUE
      into   lvalue
      from   WF_ITEM_ATTRIBUTE_VALUES
      where  ITEM_TYPE = p_item_type
      and    ITEM_KEY  = p_item_key
      and    NAME      = p_aname;