APPS.HZ_MATCH_RULE_34 dependencies on HZ_CONTACT_POINTS

Line 743: FROM HZ_CONTACT_POINTS

739: END IF;
740: IF p_attribute = 'PHONE_AREA_CODE' THEN
741: BEGIN
742: SELECT PHONE_AREA_CODE INTO l_matched_value
743: FROM HZ_CONTACT_POINTS
744: WHERE contact_point_id = p_record_id and rownum=1;
745: EXCEPTION
746: WHEN NO_DATA_FOUND THEN
747: l_matched_value := 'Err';

Line 754: FROM HZ_CONTACT_POINTS

750: END IF;
751: IF p_attribute = 'PHONE_COUNTRY_CODE' THEN
752: BEGIN
753: SELECT PHONE_COUNTRY_CODE INTO l_matched_value
754: FROM HZ_CONTACT_POINTS
755: WHERE contact_point_id = p_record_id and rownum=1;
756: EXCEPTION
757: WHEN NO_DATA_FOUND THEN
758: l_matched_value := 'Err';

Line 5276: from hz_contact_points

5272: p_party_site_list HZ_PARTY_SEARCH.IDList;
5273: p_contact_ids HZ_PARTY_SEARCH.IDList;
5274: l_match_idx NUMBER;
5275: cursor get_cpts_for_party_sites is select contact_point_id
5276: from hz_contact_points
5277: where owner_table_name = 'HZ_PARTY_SITES'
5278: and primary_flag='Y'
5279: and owner_table_id = p_party_site_id;
5280: BEGIN

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

5357: p_party_site_list HZ_PARTY_SEARCH.IDList;
5358: p_contact_ids HZ_PARTY_SEARCH.IDList;
5359: l_match_idx NUMBER;
5360: cursor get_cpt_for_contact_id is select contact_point_id
5361: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5362: where a.party_relationship_id = b.relationship_id
5363: and c.owner_table_name = 'HZ_PARTIES'
5364: and c.primary_flag='Y'
5365: and c.owner_table_id = b.party_id

Line 6865: FROM HZ_CONTACT_POINTS

6861: ps:=ps+1;
6862: END LOOP;
6863: FOR CONTACT_POINTS IN (
6864: SELECT CONTACT_POINT_ID
6865: FROM HZ_CONTACT_POINTS
6866: WHERE PRIMARY_FLAG = 'Y'
6867: AND owner_table_name = 'HZ_PARTIES'
6868: AND owner_table_id = p_party_id
6869:

Line 6873: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6869:
6870: UNION
6871:
6872: SELECT CONTACT_POINT_ID
6873: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6874: WHERE PRIMARY_FLAG = 'Y'
6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6877: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6886: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6882: AND ROWNUM<6
6883: UNION
6884:
6885: SELECT CONTACT_POINT_ID
6886: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6887: WHERE PRIMARY_FLAG = 'Y'
6888: AND owner_table_name = 'HZ_PARTY_SITES'
6889: AND owner_table_id = party_site_id
6890: AND PARTY_ID = p_party_id

Line 7178: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')

7174:
7175: -- Cursor to fetch primary contact points for party
7176: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7177: SELECT contact_point_id, contact_point_type
7178: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7179: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7180: FROM HZ_CONTACT_POINTS
7181: WHERE contact_point_id = cp_contact_point_id;
7182:

Line 7179: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')

7175: -- Cursor to fetch primary contact points for party
7176: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7177: SELECT contact_point_id, contact_point_type
7178: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7179: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7180: FROM HZ_CONTACT_POINTS
7181: WHERE contact_point_id = cp_contact_point_id;
7182:
7183: I NUMBER;

Line 7180: FROM HZ_CONTACT_POINTS

7176: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7177: SELECT contact_point_id, contact_point_type
7178: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7179: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7180: FROM HZ_CONTACT_POINTS
7181: WHERE contact_point_id = cp_contact_point_id;
7182:
7183: I NUMBER;
7184: l_contact_point_id NUMBER;