APPS.HZ_MATCH_RULE_3 dependencies on HZ_CONTACT_POINTS

Line 320: FROM HZ_CONTACT_POINTS

316: END IF;
317: IF p_attribute = 'EMAIL_ADDRESS' THEN
318: BEGIN
319: SELECT EMAIL_ADDRESS INTO l_matched_value
320: FROM HZ_CONTACT_POINTS
321: WHERE contact_point_id = p_record_id and rownum=1;
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: l_matched_value := 'Err';

Line 3820: from hz_contact_points

3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3818: l_match_idx NUMBER;
3819: cursor get_cpts_for_party_sites is select contact_point_id
3820: from hz_contact_points
3821: where owner_table_name = 'HZ_PARTY_SITES'
3822: and primary_flag='Y'
3823: and owner_table_id = p_party_site_id;
3824: BEGIN

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

3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3903: l_match_idx NUMBER;
3904: cursor get_cpt_for_contact_id is select contact_point_id
3905: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3906: where a.party_relationship_id = b.relationship_id
3907: and c.owner_table_name = 'HZ_PARTIES'
3908: and c.primary_flag='Y'
3909: and c.owner_table_id = b.party_id

Line 5176: FROM HZ_CONTACT_POINTS

5172: END IF;
5173: l_party_id := p_party_id;
5174: FOR CONTACT_POINTS IN (
5175: SELECT CONTACT_POINT_ID
5176: FROM HZ_CONTACT_POINTS
5177: WHERE PRIMARY_FLAG = 'Y'
5178: AND owner_table_name = 'HZ_PARTIES'
5179: AND owner_table_id = p_party_id
5180:

Line 5184: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5180:
5181: UNION
5182:
5183: SELECT CONTACT_POINT_ID
5184: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5185: WHERE PRIMARY_FLAG = 'Y'
5186: AND owner_table_name = 'HZ_PARTIES'
5187: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5188: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5197: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5193: AND ROWNUM<6
5194: UNION
5195:
5196: SELECT CONTACT_POINT_ID
5197: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5198: WHERE PRIMARY_FLAG = 'Y'
5199: AND owner_table_name = 'HZ_PARTY_SITES'
5200: AND owner_table_id = party_site_id
5201: AND PARTY_ID = p_party_id

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

5439:
5440: -- Cursor to fetch primary contact points for party
5441: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5442: SELECT contact_point_id, contact_point_type
5443: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5444: FROM HZ_CONTACT_POINTS
5445: WHERE contact_point_id = cp_contact_point_id;
5446:
5447: I NUMBER;

Line 5444: FROM HZ_CONTACT_POINTS

5440: -- Cursor to fetch primary contact points for party
5441: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5442: SELECT contact_point_id, contact_point_type
5443: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5444: FROM HZ_CONTACT_POINTS
5445: WHERE contact_point_id = cp_contact_point_id;
5446:
5447: I NUMBER;
5448: l_contact_point_id NUMBER;