475: IF p_end_date < SYSDATE THEN
476: SELECT MAX(t.transaction_date)
477: INTO l_transaction_date
478: FROM csi_i_assets_h s,
479: csi_transactions t
480: WHERE s.instance_asset_id=p_inst_asset_id
481: AND s.transaction_id=t.transaction_id
482: AND t.transaction_id <> nvl(p_txn_id, -999999);
483: