TekPortfolio V3.2 Patch 018
Copyright (c) 2000-2007.  Intuit Inc.  All Rights Reserved.

05/14/2007

Please refer to the TekPortfolio Programmer's Guide for installation
instructions.


Changes:
- TeamTrack #CSC000752.  Inefficient query on Categories Selection report. The WHERE clause in the SQL did not include TP_CUSTOMER_ID.  Changed SQL to include TP_CUSTOMER_ID and POSTED_DATE.

- Fix for ER #25

During 'delete' account in account manage page:
Previously we were checking only the 'status' field in TP_TRANSFERS_HISTORY table to determine whether it is a inprocess transfer or not, when user is trying to delete associated account.
Now checking null values in transfer_date_to and transfer_date_from field of the record. if either of them is null, that particular record will be treated as in process transfer.

- Removed code that added the Oracle TO_DATE function to the Categories Select SQL statement.  There's a property within TekPortfolio.Customer.properties named 'UI.databaseDateFormat' that already controls this.  The code removal fixed having the TO_DATE function added twice to the SQL.