APPS.HZ_MATCH_RULE_42 dependencies on HZ_CONTACT_POINTS

Line 739: FROM HZ_CONTACT_POINTS

735: END IF;
736: IF p_attribute = 'EMAIL_ADDRESS' THEN
737: BEGIN
738: SELECT EMAIL_ADDRESS INTO l_matched_value
739: FROM HZ_CONTACT_POINTS
740: WHERE contact_point_id = p_record_id and rownum=1;
741: EXCEPTION
742: WHEN NO_DATA_FOUND THEN
743: l_matched_value := 'Err';

Line 5281: from hz_contact_points

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

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

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

Line 6862: FROM HZ_CONTACT_POINTS

6858: ct := ct+1;
6859: END LOOP;
6860: FOR CONTACT_POINTS IN (
6861: SELECT CONTACT_POINT_ID
6862: FROM HZ_CONTACT_POINTS
6863: WHERE PRIMARY_FLAG = 'Y'
6864: AND owner_table_name = 'HZ_PARTIES'
6865: AND owner_table_id = p_party_id
6866:

Line 6870: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

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

Line 6883: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

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

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

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

Line 7188: FROM HZ_CONTACT_POINTS

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