APPS.HZ_MATCH_RULE_238 dependencies on HZ_CONTACT_POINTS

Line 390: FROM HZ_CONTACT_POINTS

386: IF p_entity = 'CONTACT_POINTS' THEN
387: IF p_attribute = 'PHONE_NUMBER' THEN
388: BEGIN
389: SELECT PHONE_NUMBER INTO l_matched_value
390: FROM HZ_CONTACT_POINTS
391: WHERE contact_point_id = p_record_id and rownum=1;
392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: l_matched_value := 'Err';

Line 4174: from hz_contact_points

4170: p_party_site_list HZ_PARTY_SEARCH.IDList;
4171: p_contact_ids HZ_PARTY_SEARCH.IDList;
4172: l_match_idx NUMBER;
4173: cursor get_cpts_for_party_sites is select contact_point_id
4174: from hz_contact_points
4175: where owner_table_name = 'HZ_PARTY_SITES'
4176: and primary_flag='Y'
4177: and owner_table_id = p_party_site_id;
4178: BEGIN

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

4255: p_party_site_list HZ_PARTY_SEARCH.IDList;
4256: p_contact_ids HZ_PARTY_SEARCH.IDList;
4257: l_match_idx NUMBER;
4258: cursor get_cpt_for_contact_id is select contact_point_id
4259: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4260: where a.party_relationship_id = b.relationship_id
4261: and c.owner_table_name = 'HZ_PARTIES'
4262: and c.primary_flag='Y'
4263: and c.owner_table_id = b.party_id

Line 5561: FROM HZ_CONTACT_POINTS

5557: ps:=ps+1;
5558: END LOOP;
5559: FOR CONTACT_POINTS IN (
5560: SELECT CONTACT_POINT_ID
5561: FROM HZ_CONTACT_POINTS
5562: WHERE PRIMARY_FLAG = 'Y'
5563: AND owner_table_name = 'HZ_PARTIES'
5564: AND owner_table_id = p_party_id
5565:

Line 5569: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5565:
5566: UNION
5567:
5568: SELECT CONTACT_POINT_ID
5569: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5570: WHERE PRIMARY_FLAG = 'Y'
5571: AND owner_table_name = 'HZ_PARTIES'
5572: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5573: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5582: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5578: AND ROWNUM<6
5579: UNION
5580:
5581: SELECT CONTACT_POINT_ID
5582: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5583: WHERE PRIMARY_FLAG = 'Y'
5584: AND owner_table_name = 'HZ_PARTY_SITES'
5585: AND owner_table_id = party_site_id
5586: AND PARTY_ID = p_party_id

Line 5840: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')

5836:
5837: -- Cursor to fetch primary contact points for party
5838: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5839: SELECT contact_point_id, contact_point_type
5840: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')
5841: FROM HZ_CONTACT_POINTS
5842: WHERE contact_point_id = cp_contact_point_id;
5843:
5844: I NUMBER;

Line 5841: FROM HZ_CONTACT_POINTS

5837: -- Cursor to fetch primary contact points for party
5838: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5839: SELECT contact_point_id, contact_point_type
5840: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')
5841: FROM HZ_CONTACT_POINTS
5842: WHERE contact_point_id = cp_contact_point_id;
5843:
5844: I NUMBER;
5845: l_contact_point_id NUMBER;