Very interesting I did not think of that at all.

The query was passed on to me to call from a package.

I will have to ask the creator more questions but it seems as they are trying to create unique values by not only using the concat in the WHERE clause but also in the SELECT statement.

The statements are used to update and insert into look-up tables.