APPS.HZ_MATCH_RULE_98 dependencies on HZ_CONTACT_POINTS

Line 340: FROM HZ_CONTACT_POINTS

336: END IF;
337: IF p_attribute = 'EMAIL_ADDRESS' THEN
338: BEGIN
339: SELECT EMAIL_ADDRESS INTO l_matched_value
340: FROM HZ_CONTACT_POINTS
341: WHERE contact_point_id = p_record_id and rownum=1;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN
344: l_matched_value := 'Err';

Line 4037: from hz_contact_points

4033: p_party_site_list HZ_PARTY_SEARCH.IDList;
4034: p_contact_ids HZ_PARTY_SEARCH.IDList;
4035: l_match_idx NUMBER;
4036: cursor get_cpts_for_party_sites is select contact_point_id
4037: from hz_contact_points
4038: where owner_table_name = 'HZ_PARTY_SITES'
4039: and primary_flag='Y'
4040: and owner_table_id = p_party_site_id;
4041: BEGIN

Line 4122: from hz_org_contacts a, hz_relationships b, hz_contact_points c

4118: p_party_site_list HZ_PARTY_SEARCH.IDList;
4119: p_contact_ids HZ_PARTY_SEARCH.IDList;
4120: l_match_idx NUMBER;
4121: cursor get_cpt_for_contact_id is select contact_point_id
4122: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4123: where a.party_relationship_id = b.relationship_id
4124: and c.owner_table_name = 'HZ_PARTIES'
4125: and c.primary_flag='Y'
4126: and c.owner_table_id = b.party_id

Line 5412: FROM HZ_CONTACT_POINTS

5408: ct := ct+1;
5409: END LOOP;
5410: FOR CONTACT_POINTS IN (
5411: SELECT CONTACT_POINT_ID
5412: FROM HZ_CONTACT_POINTS
5413: WHERE PRIMARY_FLAG = 'Y'
5414: AND owner_table_name = 'HZ_PARTIES'
5415: AND owner_table_id = p_party_id
5416:

Line 5420: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5416:
5417: UNION
5418:
5419: SELECT CONTACT_POINT_ID
5420: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5421: WHERE PRIMARY_FLAG = 'Y'
5422: AND owner_table_name = 'HZ_PARTIES'
5423: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5424: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5433: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5429: AND ROWNUM<6
5430: UNION
5431:
5432: SELECT CONTACT_POINT_ID
5433: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5434: WHERE PRIMARY_FLAG = 'Y'
5435: AND owner_table_name = 'HZ_PARTY_SITES'
5436: AND owner_table_id = party_site_id
5437: AND PARTY_ID = p_party_id

Line 5671: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')

5667:
5668: -- Cursor to fetch primary contact points for party
5669: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5670: SELECT contact_point_id, contact_point_type
5671: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5672: FROM HZ_CONTACT_POINTS
5673: WHERE contact_point_id = cp_contact_point_id;
5674:
5675: I NUMBER;

Line 5672: FROM HZ_CONTACT_POINTS

5668: -- Cursor to fetch primary contact points for party
5669: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5670: SELECT contact_point_id, contact_point_type
5671: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5672: FROM HZ_CONTACT_POINTS
5673: WHERE contact_point_id = cp_contact_point_id;
5674:
5675: I NUMBER;
5676: l_contact_point_id NUMBER;