APPS.OKL_AM_REMARKET_ASSET_WF SQL Statements

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

Line: 27

  	SELECT okl_wf_item_s.nextval
  	FROM   DUAL;

Line: 77

    l_parameter_list.DELETE;

Line: 109

	l_LAST_UPDATED_BY			NUMBER;

Line: 116

	SELECT last_updated_by
	FROM   okl_asset_returns_b
	WHERE  id = cp_asset_return_id;

Line: 129

		FETCH l_assetreturn_csr INTO l_LAST_UPDATED_BY;

Line: 132

		IF l_LAST_UPDATED_BY IS NULL THEN
		   resultout := 'COMPLETE:INVALID';

Line: 140

                              , p_user_id     => l_last_updated_by
                              , x_name  	  => l_user
	                          , x_description => l_name);

Line: 201

	-- get last_updated_by
	CURSOR l_assetreturn_csr(cp_asset_return_id IN NUMBER) IS
	SELECT last_updated_by
	FROM   okl_asset_returns_b
	WHERE  id = cp_asset_return_id;

Line: 229

    l_last_updated_by   			NUMBER;