APPS.IEM_EMAIL_PROC_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 1181: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

1177: where owner_table_name='HZ_PARTIES'
1178: and owner_table_id=l_customer_id
1179: and contact_point_type='EMAIL'
1180: and upper(email_address)=upper(l_sender)
1181: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
1182: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
1183: exception when others then
1184: l_party_id:=null;
1185: end;