APPS.HZ_MATCH_RULE_7 dependencies on HZ_CONTACT_POINTS

Line 407: FROM HZ_CONTACT_POINTS

403: END IF;
404: IF p_attribute = 'EMAIL_ADDRESS' THEN
405: BEGIN
406: SELECT EMAIL_ADDRESS INTO l_matched_value
407: FROM HZ_CONTACT_POINTS
408: WHERE contact_point_id = p_record_id and rownum=1;
409: EXCEPTION
410: WHEN NO_DATA_FOUND THEN
411: l_matched_value := 'Err';

Line 4063: from hz_contact_points

4059: p_party_site_list HZ_PARTY_SEARCH.IDList;
4060: p_contact_ids HZ_PARTY_SEARCH.IDList;
4061: l_match_idx NUMBER;
4062: cursor get_cpts_for_party_sites is select contact_point_id
4063: from hz_contact_points
4064: where owner_table_name = 'HZ_PARTY_SITES'
4065: and primary_flag='Y'
4066: and owner_table_id = p_party_site_id;
4067: BEGIN

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

4144: p_party_site_list HZ_PARTY_SEARCH.IDList;
4145: p_contact_ids HZ_PARTY_SEARCH.IDList;
4146: l_match_idx NUMBER;
4147: cursor get_cpt_for_contact_id is select contact_point_id
4148: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4149: where a.party_relationship_id = b.relationship_id
4150: and c.owner_table_name = 'HZ_PARTIES'
4151: and c.primary_flag='Y'
4152: and c.owner_table_id = b.party_id

Line 5484: FROM HZ_CONTACT_POINTS

5480: ps:=ps+1;
5481: END LOOP;
5482: FOR CONTACT_POINTS IN (
5483: SELECT CONTACT_POINT_ID
5484: FROM HZ_CONTACT_POINTS
5485: WHERE PRIMARY_FLAG = 'Y'
5486: AND owner_table_name = 'HZ_PARTIES'
5487: AND owner_table_id = p_party_id
5488:

Line 5492: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5488:
5489: UNION
5490:
5491: SELECT CONTACT_POINT_ID
5492: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5493: WHERE PRIMARY_FLAG = 'Y'
5494: AND owner_table_name = 'HZ_PARTIES'
5495: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5496: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5505: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5501: AND ROWNUM<6
5502: UNION
5503:
5504: SELECT CONTACT_POINT_ID
5505: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5506: WHERE PRIMARY_FLAG = 'Y'
5507: AND owner_table_name = 'HZ_PARTY_SITES'
5508: AND owner_table_id = party_site_id
5509: AND PARTY_ID = p_party_id

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

5757:
5758: -- Cursor to fetch primary contact points for party
5759: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5760: SELECT contact_point_id, contact_point_type
5761: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5762: FROM HZ_CONTACT_POINTS
5763: WHERE contact_point_id = cp_contact_point_id;
5764:
5765: I NUMBER;

Line 5762: FROM HZ_CONTACT_POINTS

5758: -- Cursor to fetch primary contact points for party
5759: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5760: SELECT contact_point_id, contact_point_type
5761: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5762: FROM HZ_CONTACT_POINTS
5763: WHERE contact_point_id = cp_contact_point_id;
5764:
5765: I NUMBER;
5766: l_contact_point_id NUMBER;