APPS.HZ_MATCH_RULE_38 dependencies on HZ_CONTACT_POINTS

Line 518: FROM HZ_CONTACT_POINTS

514: END IF;
515: IF p_attribute = 'EMAIL_ADDRESS' THEN
516: BEGIN
517: SELECT EMAIL_ADDRESS INTO l_matched_value
518: FROM HZ_CONTACT_POINTS
519: WHERE contact_point_id = p_record_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: l_matched_value := 'Err';

Line 4377: from hz_contact_points

4373: p_party_site_list HZ_PARTY_SEARCH.IDList;
4374: p_contact_ids HZ_PARTY_SEARCH.IDList;
4375: l_match_idx NUMBER;
4376: cursor get_cpts_for_party_sites is select contact_point_id
4377: from hz_contact_points
4378: where owner_table_name = 'HZ_PARTY_SITES'
4379: and primary_flag='Y'
4380: and owner_table_id = p_party_site_id;
4381: BEGIN

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

4458: p_party_site_list HZ_PARTY_SEARCH.IDList;
4459: p_contact_ids HZ_PARTY_SEARCH.IDList;
4460: l_match_idx NUMBER;
4461: cursor get_cpt_for_contact_id is select contact_point_id
4462: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4463: where a.party_relationship_id = b.relationship_id
4464: and c.owner_table_name = 'HZ_PARTIES'
4465: and c.primary_flag='Y'
4466: and c.owner_table_id = b.party_id

Line 5882: FROM HZ_CONTACT_POINTS

5878: ct := ct+1;
5879: END LOOP;
5880: FOR CONTACT_POINTS IN (
5881: SELECT CONTACT_POINT_ID
5882: FROM HZ_CONTACT_POINTS
5883: WHERE PRIMARY_FLAG = 'Y'
5884: AND owner_table_name = 'HZ_PARTIES'
5885: AND owner_table_id = p_party_id
5886:

Line 5890: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5886:
5887: UNION
5888:
5889: SELECT CONTACT_POINT_ID
5890: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5891: WHERE PRIMARY_FLAG = 'Y'
5892: AND owner_table_name = 'HZ_PARTIES'
5893: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5894: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5903: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5899: AND ROWNUM<6
5900: UNION
5901:
5902: SELECT CONTACT_POINT_ID
5903: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5904: WHERE PRIMARY_FLAG = 'Y'
5905: AND owner_table_name = 'HZ_PARTY_SITES'
5906: AND owner_table_id = party_site_id
5907: AND PARTY_ID = p_party_id

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

6157:
6158: -- Cursor to fetch primary contact points for party
6159: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6160: SELECT contact_point_id, contact_point_type
6161: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6162: FROM HZ_CONTACT_POINTS
6163: WHERE contact_point_id = cp_contact_point_id;
6164:
6165: I NUMBER;

Line 6162: FROM HZ_CONTACT_POINTS

6158: -- Cursor to fetch primary contact points for party
6159: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6160: SELECT contact_point_id, contact_point_type
6161: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6162: FROM HZ_CONTACT_POINTS
6163: WHERE contact_point_id = cp_contact_point_id;
6164:
6165: I NUMBER;
6166: l_contact_point_id NUMBER;