APPS.IEX_CUST_OVERVIEW_PVT dependencies on HZ_CONTACT_POINTS

Line 1635: FROM hz_contact_points

1631: DECODE(PRIMARY_FLAG, 'Y', 1, 2) C3,
1632: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1633: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1634: email_address, contact_point_type
1635: FROM hz_contact_points
1636: WHERE owner_table_name = 'HZ_PARTIES'
1637: AND owner_table_id = x_party_id
1638: AND ((contact_point_type = 'EMAIL') OR
1639: (contact_point_type = 'PHONE' AND phone_line_type NOT IN ('PAGER', 'FAX')))

Line 2549: FROM hz_contact_points

2545: WHERE party_id = p_party_id;
2546:
2547: CURSOR c_contact_point(p_contact_point_id NUMBER) is
2548: SELECT *
2549: FROM hz_contact_points
2550: WHERE contact_point_id = p_contact_point_id;
2551:
2552: l_phone_rec c_contact_point%ROWTYPE;
2553: l_email_rec c_contact_point%ROWTYPE;