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 5289: from hz_contact_points

5285: p_party_site_list HZ_PARTY_SEARCH.IDList;
5286: p_contact_ids HZ_PARTY_SEARCH.IDList;
5287: l_match_idx NUMBER;
5288: cursor get_cpts_for_party_sites is select contact_point_id
5289: from hz_contact_points
5290: where owner_table_name = 'HZ_PARTY_SITES'
5291: and primary_flag='Y'
5292: and owner_table_id = p_party_site_id;
5293: BEGIN

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

5370: p_party_site_list HZ_PARTY_SEARCH.IDList;
5371: p_contact_ids HZ_PARTY_SEARCH.IDList;
5372: l_match_idx NUMBER;
5373: cursor get_cpt_for_contact_id is select contact_point_id
5374: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5375: where a.party_relationship_id = b.relationship_id
5376: and c.owner_table_name = 'HZ_PARTIES'
5377: and c.primary_flag='Y'
5378: and c.owner_table_id = b.party_id

Line 6873: FROM HZ_CONTACT_POINTS

6869: ct := ct+1;
6870: END LOOP;
6871: FOR CONTACT_POINTS IN (
6872: SELECT CONTACT_POINT_ID
6873: FROM HZ_CONTACT_POINTS
6874: WHERE PRIMARY_FLAG = 'Y'
6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND owner_table_id = p_party_id
6877:

Line 6881: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6877:
6878: UNION
6879:
6880: SELECT CONTACT_POINT_ID
6881: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6882: WHERE PRIMARY_FLAG = 'Y'
6883: AND owner_table_name = 'HZ_PARTIES'
6884: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6885: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6894: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6890: AND ROWNUM<6
6891: UNION
6892:
6893: SELECT CONTACT_POINT_ID
6894: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6895: WHERE PRIMARY_FLAG = 'Y'
6896: AND owner_table_name = 'HZ_PARTY_SITES'
6897: AND owner_table_id = party_site_id
6898: AND PARTY_ID = p_party_id

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

7194:
7195: -- Cursor to fetch primary contact points for party
7196: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7197: SELECT contact_point_id, contact_point_type
7198: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
7199: FROM HZ_CONTACT_POINTS
7200: WHERE contact_point_id = cp_contact_point_id;
7201:
7202: I NUMBER;

Line 7199: FROM HZ_CONTACT_POINTS

7195: -- Cursor to fetch primary contact points for party
7196: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
7197: SELECT contact_point_id, contact_point_type
7198: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
7199: FROM HZ_CONTACT_POINTS
7200: WHERE contact_point_id = cp_contact_point_id;
7201:
7202: I NUMBER;
7203: l_contact_point_id NUMBER;