The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM csi_item_instances
WHERE instance_id = p_instance_id
and ((active_end_date is null) OR (active_end_date >= sysdate));
SELECT 'x'
FROM csi_item_instances
WHERE instance_id = p_instance_id;
SELECT CSI_I_ASSETS_S.nextval
INTO l_inst_asset_id
FROM sys.dual;
SELECT 'x'
INTO l_dummy
FROM csi_i_assets
WHERE instance_asset_id = p_instance_asset_id ;
SELECT 'x'
INTO l_dummy
FROM csi_i_assets
WHERE instance_asset_id = p_instance_asset_id ;
/* Procedure name: Is_Update_Status_Exists */
/* Description : Check if the update status is */
/* defined in CSI_LOOKUPS */
/*-----------------------------------------------------------*/
FUNCTION Is_Update_Status_Exists
(
p_update_status IN VARCHAR2,
p_stack_err_msg IN BOOLEAN
) RETURN BOOLEAN IS
l_dummy VARCHAR2(1);
l_asset_lookup_type VARCHAR2(30) := 'CSI_ASSET_UPDATE_STATUS_CODE';
SELECT 'x'
FROM CSI_LOOKUPS
WHERE UPPER(lookup_code) = UPPER(p_update_status)
AND lookup_type = l_asset_lookup_type;
FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
END Is_Update_Status_Exists;
SELECT CSI_I_ASSETS_H_S.nextval
INTO l_inst_asset_hist_id
FROM sys.dual;
SELECT 'x'
FROM fa_books
WHERE asset_id = p_asset_id
and book_type_code = p_book_type_code
and rownum = 1 ;
SELECT 'x'
INTO l_dummy
FROM csi_a_locations
WHERE fa_location_id = p_location_id
and ((active_end_date is null) OR (active_end_date >= sysdate))
and ROWNUM = 1;
SELECT active_start_date,
active_end_date
FROM csi_item_instances
WHERE instance_id = p_instance_id
AND ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));
SELECT active_start_date,
active_end_date
FROM csi_item_instances
WHERE instance_id = p_instance_id;
SELECT MAX(t.transaction_date)
INTO l_transaction_date
FROM csi_i_assets_h s,
csi_transactions t
WHERE s.instance_asset_id=p_inst_asset_id
AND s.transaction_id=t.transaction_id
AND t.transaction_id <> nvl(p_txn_id, -999999);