APPS.HZ_MATCH_RULE_32 dependencies on HZ_CONTACT_POINTS

Line 625: FROM HZ_CONTACT_POINTS

621: END IF;
622: IF p_attribute = 'EMAIL_ADDRESS' THEN
623: BEGIN
624: SELECT EMAIL_ADDRESS INTO l_matched_value
625: FROM HZ_CONTACT_POINTS
626: WHERE contact_point_id = p_record_id and rownum=1;
627: EXCEPTION
628: WHEN NO_DATA_FOUND THEN
629: l_matched_value := 'Err';

Line 4896: from hz_contact_points

4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4894: l_match_idx NUMBER;
4895: cursor get_cpts_for_party_sites is select contact_point_id
4896: from hz_contact_points
4897: where owner_table_name = 'HZ_PARTY_SITES'
4898: and primary_flag='Y'
4899: and owner_table_id = p_party_site_id;
4900: BEGIN

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

4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4979: l_match_idx NUMBER;
4980: cursor get_cpt_for_contact_id is select contact_point_id
4981: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4982: where a.party_relationship_id = b.relationship_id
4983: and c.owner_table_name = 'HZ_PARTIES'
4984: and c.primary_flag='Y'
4985: and c.owner_table_id = b.party_id

Line 6434: FROM HZ_CONTACT_POINTS

6430: ct := ct+1;
6431: END LOOP;
6432: FOR CONTACT_POINTS IN (
6433: SELECT CONTACT_POINT_ID
6434: FROM HZ_CONTACT_POINTS
6435: WHERE PRIMARY_FLAG = 'Y'
6436: AND owner_table_name = 'HZ_PARTIES'
6437: AND owner_table_id = p_party_id
6438:

Line 6442: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6438:
6439: UNION
6440:
6441: SELECT CONTACT_POINT_ID
6442: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6443: WHERE PRIMARY_FLAG = 'Y'
6444: AND owner_table_name = 'HZ_PARTIES'
6445: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6446: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6455: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6451: AND ROWNUM<6
6452: UNION
6453:
6454: SELECT CONTACT_POINT_ID
6455: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6456: WHERE PRIMARY_FLAG = 'Y'
6457: AND owner_table_name = 'HZ_PARTY_SITES'
6458: AND owner_table_id = party_site_id
6459: AND PARTY_ID = p_party_id

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

6735:
6736: -- Cursor to fetch primary contact points for party
6737: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6738: SELECT contact_point_id, contact_point_type
6739: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6740: FROM HZ_CONTACT_POINTS
6741: WHERE contact_point_id = cp_contact_point_id;
6742:
6743: I NUMBER;

Line 6740: FROM HZ_CONTACT_POINTS

6736: -- Cursor to fetch primary contact points for party
6737: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6738: SELECT contact_point_id, contact_point_type
6739: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6740: FROM HZ_CONTACT_POINTS
6741: WHERE contact_point_id = cp_contact_point_id;
6742:
6743: I NUMBER;
6744: l_contact_point_id NUMBER;