DaPi - I knew you were out there
How do I code the NOT Exists ??
I'll have another go, whilst I wait for your wisdom........

and (hurn,purn,cat_id) not exists (select hurn,purn,cat_id from affected_catalogue_customer)
*
ERROR at line 13:
ORA-00920: invalid relational operator