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 4266: from hz_contact_points

4262: p_party_site_list HZ_PARTY_SEARCH.IDList;
4263: p_contact_ids HZ_PARTY_SEARCH.IDList;
4264: l_match_idx NUMBER;
4265: cursor get_cpts_for_party_sites is select contact_point_id
4266: from hz_contact_points
4267: where owner_table_name = 'HZ_PARTY_SITES'
4268: and primary_flag='Y'
4269: and owner_table_id = p_party_site_id;
4270: BEGIN

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

4347: p_party_site_list HZ_PARTY_SEARCH.IDList;
4348: p_contact_ids HZ_PARTY_SEARCH.IDList;
4349: l_match_idx NUMBER;
4350: cursor get_cpt_for_contact_id is select contact_point_id
4351: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4352: where a.party_relationship_id = b.relationship_id
4353: and c.owner_table_name = 'HZ_PARTIES'
4354: and c.primary_flag='Y'
4355: and c.owner_table_id = b.party_id

Line 5668: FROM HZ_CONTACT_POINTS

5664: ct := ct+1;
5665: END LOOP;
5666: FOR CONTACT_POINTS IN (
5667: SELECT CONTACT_POINT_ID
5668: FROM HZ_CONTACT_POINTS
5669: WHERE PRIMARY_FLAG = 'Y'
5670: AND owner_table_name = 'HZ_PARTIES'
5671: AND owner_table_id = p_party_id
5672:

Line 5676: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5672:
5673: UNION
5674:
5675: SELECT CONTACT_POINT_ID
5676: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5677: WHERE PRIMARY_FLAG = 'Y'
5678: AND owner_table_name = 'HZ_PARTIES'
5679: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5680: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5689: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5685: AND ROWNUM<6
5686: UNION
5687:
5688: SELECT CONTACT_POINT_ID
5689: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5690: WHERE PRIMARY_FLAG = 'Y'
5691: AND owner_table_name = 'HZ_PARTY_SITES'
5692: AND owner_table_id = party_site_id
5693: AND PARTY_ID = p_party_id

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

5943:
5944: -- Cursor to fetch primary contact points for party
5945: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5946: SELECT contact_point_id, contact_point_type
5947: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5948: FROM HZ_CONTACT_POINTS
5949: WHERE contact_point_id = cp_contact_point_id;
5950:
5951: I NUMBER;

Line 5948: FROM HZ_CONTACT_POINTS

5944: -- Cursor to fetch primary contact points for party
5945: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5946: SELECT contact_point_id, contact_point_type
5947: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5948: FROM HZ_CONTACT_POINTS
5949: WHERE contact_point_id = cp_contact_point_id;
5950:
5951: I NUMBER;
5952: l_contact_point_id NUMBER;