APPS.IEM_GETCUST_PVT dependencies on HZ_CONTACT_PREFERENCES

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

45: and a.status='A'
46: and b.status = 'A'
47: and b.party_id=a.owner_table_id
48: and upper(a.email_address)=upper(p_email)
49: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
50: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
51: /*select owner_table_id into p_party_id
52: from hz_contact_points
53: where owner_table_name='HZ_PARTIES'

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

53: where owner_table_name='HZ_PARTIES'
54: and contact_point_type='EMAIL'
55: and status='A'
56: and upper(email_address)=upper(p_email)
57: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
58: where contact_level_table='HZ_CONTACT_POINTS' and status='A');*/
59: EXCEPTION
60: WHEN NO_DATA_FOUND THEN
61: p_party_id:=-1;

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

100: and a.contact_point_type='EMAIL'
101: and a.status='A'
102: AND b.status = 'A'--Fix for bug 14337195 - 7/30/2012 - Sharanya R
103: and b.party_id=a.owner_table_id
104: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
105: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
106: order by 2,1 DESC;
107: BEGIN
108: -- Standard call to check for call compatibility.