APPS.IEX_CUST_OVERVIEW_PVT dependencies on HZ_CONTACT_POINTS

Line 1750: FROM hz_contact_points

1746: DECODE(PRIMARY_FLAG, 'Y', 1, 2) C3,
1747: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1748: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1749: email_address, contact_point_type
1750: FROM hz_contact_points
1751: WHERE owner_table_name = 'HZ_PARTIES'
1752: AND owner_table_id = x_party_id
1753: AND ((contact_point_type = 'EMAIL') OR
1754: (contact_point_type = 'PHONE' AND phone_line_type NOT IN ('PAGER', 'FAX')))

Line 2758: FROM hz_contact_points

2754: WHERE party_id = p_party_id;
2755:
2756: CURSOR c_contact_point(p_contact_point_id NUMBER) is
2757: SELECT *
2758: FROM hz_contact_points
2759: WHERE contact_point_id = p_contact_point_id;
2760:
2761: --Begin Bug 6509624 31-Mar-2009 barathsr
2762: CURSOR c_phone_contact_point(p_contact_point_id NUMBER) is

Line 2764: FROM hz_contact_points

2760:
2761: --Begin Bug 6509624 31-Mar-2009 barathsr
2762: CURSOR c_phone_contact_point(p_contact_point_id NUMBER) is
2763: SELECT *
2764: FROM hz_contact_points
2765: WHERE owner_table_id=( SELECT owner_table_id
2766: FROM hz_contact_points
2767: WHERE contact_point_id = p_contact_point_id)
2768: AND contact_point_purpose=p_type

Line 2766: FROM hz_contact_points

2762: CURSOR c_phone_contact_point(p_contact_point_id NUMBER) is
2763: SELECT *
2764: FROM hz_contact_points
2765: WHERE owner_table_id=( SELECT owner_table_id
2766: FROM hz_contact_points
2767: WHERE contact_point_id = p_contact_point_id)
2768: AND contact_point_purpose=p_type
2769: AND contact_point_type ='PHONE'
2770: --Begin Bug 8322090 07-Apr-2009 barathsr

Line 2773: FROM hz_contact_points

2769: AND contact_point_type ='PHONE'
2770: --Begin Bug 8322090 07-Apr-2009 barathsr
2771: UNION
2772: select *
2773: FROM hz_contact_points
2774: WHERE contact_point_id = p_contact_point_id;
2775: --End Bug 8322090 07-Apr-2009 barathsr
2776:
2777: l_phone_rec c_phone_contact_point%ROWTYPE;