APPS.OE_HOLDS_WF SQL Statements

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

Line: 105

 	SELECT header_id
	INTO l_header_id
      	FROM oe_order_lines
       	WHERE line_id = to_number(itemkey);

Line: 130

	   SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
	   INTO l_wf_item, l_wf_activity
	   FROM WF_ITEM_ACTIVITY_STATUSES IAS,
	        WF_PROCESS_ACTIVITIES CHILD,
	        WF_PROCESS_ACTIVITIES PARENT
	   WHERE CHILD.INSTANCE_ID = actid
	   AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE
	   AND CHILD.PROCESS_NAME = PARENT.ACTIVITY_NAME
	   AND PARENT.INSTANCE_ID = IAS.PROCESS_ACTIVITY
	   AND IAS.ITEM_TYPE = itemtype
	   AND IAS.ITEM_KEY = itemkey;