APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CONTACT_POINTS

Line 111: FROM HZ_CONTACT_POINTS

107:
108: CURSOR dupcheck (source_type VARCHAR2) IS
109: SELECT
110: CONTACT_POINT_ID
111: FROM HZ_CONTACT_POINTS
112: WHERE owner_table_name = p_owner_table_name
113: AND owner_table_id = p_to_fk_id
114: AND (status IS NULL OR status = 'A')
115: AND

Line 171: FROM HZ_CONTACT_POINTS

167: PHONE_LINE_TYPE ||
168: TELEX_NUMBER ||
169: WEB_TYPE ||
170: DECODE (source_type,'P',actual_content_source,'S')
171: FROM HZ_CONTACT_POINTS
172: WHERE contact_point_id = p_from_id)
173: AND upper(nvl(EMAIL_ADDRESS,'NOEMAIL')) = ( --7294111 Added Upper
174: SELECT upper(nvl(EMAIL_ADDRESS,'NOEMAIL')) --7294111 Added Upper
175: FROM HZ_CONTACT_POINTS

Line 175: FROM HZ_CONTACT_POINTS

171: FROM HZ_CONTACT_POINTS
172: WHERE contact_point_id = p_from_id)
173: AND upper(nvl(EMAIL_ADDRESS,'NOEMAIL')) = ( --7294111 Added Upper
174: SELECT upper(nvl(EMAIL_ADDRESS,'NOEMAIL')) --7294111 Added Upper
175: FROM HZ_CONTACT_POINTS
176: WHERE contact_point_id = p_from_id)
177: AND nvl(URL, 'NOURL') = (
178: SELECT nvl(URL, 'NOURL')
179: FROM HZ_CONTACT_POINTS

Line 179: FROM HZ_CONTACT_POINTS

175: FROM HZ_CONTACT_POINTS
176: WHERE contact_point_id = p_from_id)
177: AND nvl(URL, 'NOURL') = (
178: SELECT nvl(URL, 'NOURL')
179: FROM HZ_CONTACT_POINTS
180: WHERE contact_point_id = p_from_id);
181:
182: CURSOR c_cont_source IS
183: SELECT ACTUAL_CONTENT_SOURCE

Line 184: FROM HZ_CONTACT_POINTS

180: WHERE contact_point_id = p_from_id);
181:
182: CURSOR c_cont_source IS
183: SELECT ACTUAL_CONTENT_SOURCE
184: FROM HZ_CONTACT_POINTS
185: WHERE contact_point_id = p_from_id;
186:
187: l_record_id NUMBER;
188: l_cont_source VARCHAR2(255);