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

5280: p_party_site_list HZ_PARTY_SEARCH.IDList;
5281: p_contact_ids HZ_PARTY_SEARCH.IDList;
5282: l_match_idx NUMBER;
5283: cursor get_cpts_for_party_sites is select contact_point_id
5284: from hz_contact_points
5285: where owner_table_name = 'HZ_PARTY_SITES'
5286: and primary_flag='Y'
5287: and owner_table_id = p_party_site_id;
5288: BEGIN

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

5365: p_party_site_list HZ_PARTY_SEARCH.IDList;
5366: p_contact_ids HZ_PARTY_SEARCH.IDList;
5367: l_match_idx NUMBER;
5368: cursor get_cpt_for_contact_id is select contact_point_id
5369: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5370: where a.party_relationship_id = b.relationship_id
5371: and c.owner_table_name = 'HZ_PARTIES'
5372: and c.primary_flag='Y'
5373: and c.owner_table_id = b.party_id

Line 6876: FROM HZ_CONTACT_POINTS

6872: ps:=ps+1;
6873: END LOOP;
6874: FOR CONTACT_POINTS IN (
6875: SELECT CONTACT_POINT_ID
6876: FROM HZ_CONTACT_POINTS
6877: WHERE PRIMARY_FLAG = 'Y'
6878: AND owner_table_name = 'HZ_PARTIES'
6879: AND owner_table_id = p_party_id
6880:

Line 6884: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6880:
6881: UNION
6882:
6883: SELECT CONTACT_POINT_ID
6884: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6885: WHERE PRIMARY_FLAG = 'Y'
6886: AND owner_table_name = 'HZ_PARTIES'
6887: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6888: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6897: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6893: AND ROWNUM<6
6894: UNION
6895:
6896: SELECT CONTACT_POINT_ID
6897: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6898: WHERE PRIMARY_FLAG = 'Y'
6899: AND owner_table_name = 'HZ_PARTY_SITES'
6900: AND owner_table_id = party_site_id
6901: AND PARTY_ID = p_party_id

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

7185:
7186: -- Cursor to fetch primary contact points for party
7187: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7188: SELECT contact_point_id, contact_point_type
7189: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7190: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7191: FROM HZ_CONTACT_POINTS
7192: WHERE contact_point_id = cp_contact_point_id;
7193:

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

7186: -- Cursor to fetch primary contact points for party
7187: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7188: SELECT contact_point_id, contact_point_type
7189: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7190: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7191: FROM HZ_CONTACT_POINTS
7192: WHERE contact_point_id = cp_contact_point_id;
7193:
7194: I NUMBER;

Line 7191: FROM HZ_CONTACT_POINTS

7187: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7188: SELECT contact_point_id, contact_point_type
7189: ,translate(HZ_CONTACT_POINTS.PHONE_AREA_CODE, '%',' ')
7190: ,translate(HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE, '%',' ')
7191: FROM HZ_CONTACT_POINTS
7192: WHERE contact_point_id = cp_contact_point_id;
7193:
7194: I NUMBER;
7195: l_contact_point_id NUMBER;