APPS.HZ_MATCH_RULE_58 dependencies on HZ_CONTACT_POINTS

Line 413: FROM HZ_CONTACT_POINTS

409: END IF;
410: IF p_attribute = 'EMAIL_ADDRESS' THEN
411: BEGIN
412: SELECT EMAIL_ADDRESS INTO l_matched_value
413: FROM HZ_CONTACT_POINTS
414: WHERE contact_point_id = p_record_id and rownum=1;
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: l_matched_value := 'Err';

Line 4274: from hz_contact_points

4270: p_party_site_list HZ_PARTY_SEARCH.IDList;
4271: p_contact_ids HZ_PARTY_SEARCH.IDList;
4272: l_match_idx NUMBER;
4273: cursor get_cpts_for_party_sites is select contact_point_id
4274: from hz_contact_points
4275: where owner_table_name = 'HZ_PARTY_SITES'
4276: and primary_flag='Y'
4277: and owner_table_id = p_party_site_id;
4278: BEGIN

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

4355: p_party_site_list HZ_PARTY_SEARCH.IDList;
4356: p_contact_ids HZ_PARTY_SEARCH.IDList;
4357: l_match_idx NUMBER;
4358: cursor get_cpt_for_contact_id is select contact_point_id
4359: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4360: where a.party_relationship_id = b.relationship_id
4361: and c.owner_table_name = 'HZ_PARTIES'
4362: and c.primary_flag='Y'
4363: and c.owner_table_id = b.party_id

Line 5679: FROM HZ_CONTACT_POINTS

5675: ct := ct+1;
5676: END LOOP;
5677: FOR CONTACT_POINTS IN (
5678: SELECT CONTACT_POINT_ID
5679: FROM HZ_CONTACT_POINTS
5680: WHERE PRIMARY_FLAG = 'Y'
5681: AND owner_table_name = 'HZ_PARTIES'
5682: AND owner_table_id = p_party_id
5683:

Line 5687: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5683:
5684: UNION
5685:
5686: SELECT CONTACT_POINT_ID
5687: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5688: WHERE PRIMARY_FLAG = 'Y'
5689: AND owner_table_name = 'HZ_PARTIES'
5690: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5691: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5700: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5696: AND ROWNUM<6
5697: UNION
5698:
5699: SELECT CONTACT_POINT_ID
5700: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5701: WHERE PRIMARY_FLAG = 'Y'
5702: AND owner_table_name = 'HZ_PARTY_SITES'
5703: AND owner_table_id = party_site_id
5704: AND PARTY_ID = p_party_id

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

5954:
5955: -- Cursor to fetch primary contact points for party
5956: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5957: SELECT contact_point_id, contact_point_type
5958: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5959: FROM HZ_CONTACT_POINTS
5960: WHERE contact_point_id = cp_contact_point_id;
5961:
5962: I NUMBER;

Line 5959: FROM HZ_CONTACT_POINTS

5955: -- Cursor to fetch primary contact points for party
5956: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5957: SELECT contact_point_id, contact_point_type
5958: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5959: FROM HZ_CONTACT_POINTS
5960: WHERE contact_point_id = cp_contact_point_id;
5961:
5962: I NUMBER;
5963: l_contact_point_id NUMBER;