APPS.IEM_EMAIL_PROC_PVT dependencies on HZ_RELATIONSHIPS

Line 1171: from HZ_RELATIONSHIPS where party_id= l_customer_id and

1167: if l_party_type='PARTY_RELATIONSHIP' then
1168: -- Try to identify the actual party here
1169: begin
1170: select object_id into l_party_id
1171: from HZ_RELATIONSHIPS where party_id= l_customer_id and
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