APPS.IBE_ORDER_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 272: from hz_contact_points

268: CURSOR c_contact_details(c_party_id number) IS
269: select phone_country_code,phone_area_code,phone_number,phone_extension,
270: contact_point_type, primary_flag,phone_line_type,
271: email_address
272: from hz_contact_points
273: where contact_point_type in ('PHONE','EMAIL') and
274: NVL(status, 'A') = 'A'
275: and owner_table_name = 'HZ_PARTIES'
276: and owner_table_id = c_party_id