210: IF p_end_date < sysdate THEN
211: SELECT MAX(t.transaction_date)
212: INTO l_transaction_date
213: FROM csi_i_org_assignments_h s,
214: csi_transactions t
215: WHERE s.instance_ou_id=p_instance_ou_id
216: AND s.transaction_id=t.transaction_id
217: AND t.transaction_id <> p_txn_id;
218: