APPS.HZ_MATCH_RULE_41 dependencies on HZ_CONTACT_POINTS

Line 398: FROM HZ_CONTACT_POINTS

394: END IF;
395: IF p_attribute = 'EMAIL_ADDRESS' THEN
396: BEGIN
397: SELECT EMAIL_ADDRESS INTO l_matched_value
398: FROM HZ_CONTACT_POINTS
399: WHERE contact_point_id = p_record_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: l_matched_value := 'Err';

Line 4183: from hz_contact_points

4179: p_party_site_list HZ_PARTY_SEARCH.IDList;
4180: p_contact_ids HZ_PARTY_SEARCH.IDList;
4181: l_match_idx NUMBER;
4182: cursor get_cpts_for_party_sites is select contact_point_id
4183: from hz_contact_points
4184: where owner_table_name = 'HZ_PARTY_SITES'
4185: and primary_flag='Y'
4186: and owner_table_id = p_party_site_id;
4187: BEGIN

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

4264: p_party_site_list HZ_PARTY_SEARCH.IDList;
4265: p_contact_ids HZ_PARTY_SEARCH.IDList;
4266: l_match_idx NUMBER;
4267: cursor get_cpt_for_contact_id is select contact_point_id
4268: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4269: where a.party_relationship_id = b.relationship_id
4270: and c.owner_table_name = 'HZ_PARTIES'
4271: and c.primary_flag='Y'
4272: and c.owner_table_id = b.party_id

Line 5604: FROM HZ_CONTACT_POINTS

5600: ps:=ps+1;
5601: END LOOP;
5602: FOR CONTACT_POINTS IN (
5603: SELECT CONTACT_POINT_ID
5604: FROM HZ_CONTACT_POINTS
5605: WHERE PRIMARY_FLAG = 'Y'
5606: AND owner_table_name = 'HZ_PARTIES'
5607: AND owner_table_id = p_party_id
5608:

Line 5612: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5608:
5609: UNION
5610:
5611: SELECT CONTACT_POINT_ID
5612: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5613: WHERE PRIMARY_FLAG = 'Y'
5614: AND owner_table_name = 'HZ_PARTIES'
5615: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5616: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5625: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5621: AND ROWNUM<6
5622: UNION
5623:
5624: SELECT CONTACT_POINT_ID
5625: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5626: WHERE PRIMARY_FLAG = 'Y'
5627: AND owner_table_name = 'HZ_PARTY_SITES'
5628: AND owner_table_id = party_site_id
5629: AND PARTY_ID = p_party_id

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

5877:
5878: -- Cursor to fetch primary contact points for party
5879: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5880: SELECT contact_point_id, contact_point_type
5881: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5882: FROM HZ_CONTACT_POINTS
5883: WHERE contact_point_id = cp_contact_point_id;
5884:
5885: I NUMBER;

Line 5882: FROM HZ_CONTACT_POINTS

5878: -- Cursor to fetch primary contact points for party
5879: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5880: SELECT contact_point_id, contact_point_type
5881: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5882: FROM HZ_CONTACT_POINTS
5883: WHERE contact_point_id = cp_contact_point_id;
5884:
5885: I NUMBER;
5886: l_contact_point_id NUMBER;