APPS.HZ_MATCH_RULE_99 dependencies on HZ_CONTACT_POINTS

Line 489: FROM HZ_CONTACT_POINTS

485: END IF;
486: IF p_attribute = 'EMAIL_ADDRESS' THEN
487: BEGIN
488: SELECT EMAIL_ADDRESS INTO l_matched_value
489: FROM HZ_CONTACT_POINTS
490: WHERE contact_point_id = p_record_id and rownum=1;
491: EXCEPTION
492: WHEN NO_DATA_FOUND THEN
493: l_matched_value := 'Err';

Line 4509: from hz_contact_points

4505: p_party_site_list HZ_PARTY_SEARCH.IDList;
4506: p_contact_ids HZ_PARTY_SEARCH.IDList;
4507: l_match_idx NUMBER;
4508: cursor get_cpts_for_party_sites is select contact_point_id
4509: from hz_contact_points
4510: where owner_table_name = 'HZ_PARTY_SITES'
4511: and primary_flag='Y'
4512: and owner_table_id = p_party_site_id;
4513: BEGIN

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

4590: p_party_site_list HZ_PARTY_SEARCH.IDList;
4591: p_contact_ids HZ_PARTY_SEARCH.IDList;
4592: l_match_idx NUMBER;
4593: cursor get_cpt_for_contact_id is select contact_point_id
4594: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4595: where a.party_relationship_id = b.relationship_id
4596: and c.owner_table_name = 'HZ_PARTIES'
4597: and c.primary_flag='Y'
4598: and c.owner_table_id = b.party_id

Line 6000: FROM HZ_CONTACT_POINTS

5996: ct := ct+1;
5997: END LOOP;
5998: FOR CONTACT_POINTS IN (
5999: SELECT CONTACT_POINT_ID
6000: FROM HZ_CONTACT_POINTS
6001: WHERE PRIMARY_FLAG = 'Y'
6002: AND owner_table_name = 'HZ_PARTIES'
6003: AND owner_table_id = p_party_id
6004:

Line 6008: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6004:
6005: UNION
6006:
6007: SELECT CONTACT_POINT_ID
6008: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6009: WHERE PRIMARY_FLAG = 'Y'
6010: AND owner_table_name = 'HZ_PARTIES'
6011: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6012: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6021: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6017: AND ROWNUM<6
6018: UNION
6019:
6020: SELECT CONTACT_POINT_ID
6021: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6022: WHERE PRIMARY_FLAG = 'Y'
6023: AND owner_table_name = 'HZ_PARTY_SITES'
6024: AND owner_table_id = party_site_id
6025: AND PARTY_ID = p_party_id

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

6273:
6274: -- Cursor to fetch primary contact points for party
6275: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6276: SELECT contact_point_id, contact_point_type
6277: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6278: FROM HZ_CONTACT_POINTS
6279: WHERE contact_point_id = cp_contact_point_id;
6280:
6281: I NUMBER;

Line 6278: FROM HZ_CONTACT_POINTS

6274: -- Cursor to fetch primary contact points for party
6275: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6276: SELECT contact_point_id, contact_point_type
6277: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6278: FROM HZ_CONTACT_POINTS
6279: WHERE contact_point_id = cp_contact_point_id;
6280:
6281: I NUMBER;
6282: l_contact_point_id NUMBER;