265: WHERE not exists
266: ( select aslkp.lookup_code
267: , arlkp.lookup_code
268: from AS_LOOKUPS aslkp
269: ,AR_LOOKUPS arlkp
270: ,AS_CONTACT_FAMILY acf
271: where aslkp.lookup_type = 'CONTACT_RELATION'
272: and upper(ltrim(rtrim(aslkp.meaning))) =
273: upper(ltrim(rtrim(acf.relation)))