select curTemp.cTrans_pk, TI.cInsurances_fk ;	
		from curTemp inner join Trans_Insurances TI ;
		on curTemp.cTrans_pk = TI.cTrans_fk ;	
		where TI.iSequence_Number = (select max(iSequence_Number) ;
		from Trans_Insurances X ;
		where X.cTrans_fk = TI.cTrans_fk) ;
		into cursor curTemp1