APPS.IEM_GETCUST_PVT dependencies on HZ_CONTACT_PREFERENCES

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

41: where owner_table_name='HZ_PARTIES'
42: and contact_point_type='EMAIL'
43: and status='A'
44: and upper(email_address)=upper(p_email)
45: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
46: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: p_party_id:=-1;

Line 91: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

87: and upper(a.email_address)=upper(p_email)
88: and a.contact_point_type='EMAIL'
89: and a.status='A'
90: and b.party_id=a.owner_table_id
91: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
92: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
93: order by 2,1 DESC;
94: BEGIN
95: -- Standard call to check for call compatibility.