Every row in the temp table should be checked against 1 million records ?
if the TEMP table has 1 million records ..do you think PL/SQL Cursors would be the efficient way ?