eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EMAIL_PROC_PVT dependencies on HZ_CONTACT_POINTS

Line 1176: from hz_contact_points

1172: (relationship_code='CONTACT_OF' or relationship_code='EMPLOYEE_OF')
1173: and status='A';
1174: l_contact_id:=l_customer_id;
1175: select contact_point_id into l_contact_point_id
1176: from hz_contact_points
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)

Line 1182: where contact_level_table='HZ_CONTACT_POINTS' and status='A');

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;
1186: else