APPS.HZ_MATCH_RULE_51 dependencies on HZ_CONTACT_POINTS

Line 421: FROM HZ_CONTACT_POINTS

417: IF p_entity = 'CONTACT_POINTS' THEN
418: IF p_attribute = 'EMAIL_ADDRESS' THEN
419: BEGIN
420: SELECT EMAIL_ADDRESS INTO l_matched_value
421: FROM HZ_CONTACT_POINTS
422: WHERE contact_point_id = p_record_id and rownum=1;
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: l_matched_value := 'Err';

Line 2770: from hz_contact_points

2766: p_party_site_list HZ_PARTY_SEARCH.IDList;
2767: p_contact_ids HZ_PARTY_SEARCH.IDList;
2768: l_match_idx NUMBER;
2769: cursor get_cpts_for_party_sites is select contact_point_id
2770: from hz_contact_points
2771: where owner_table_name = 'HZ_PARTY_SITES'
2772: and primary_flag='Y'
2773: and owner_table_id = p_party_site_id;
2774: BEGIN

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

2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;
2857: cursor get_cpt_for_contact_id is select contact_point_id
2858: from hz_org_contacts a, hz_relationships b, hz_contact_points c
2859: where a.party_relationship_id = b.relationship_id
2860: and c.owner_table_name = 'HZ_PARTIES'
2861: and c.primary_flag='Y'
2862: and c.owner_table_id = b.party_id

Line 4220: FROM HZ_CONTACT_POINTS

4216: ps:=ps+1;
4217: END LOOP;
4218: FOR CONTACT_POINTS IN (
4219: SELECT CONTACT_POINT_ID
4220: FROM HZ_CONTACT_POINTS
4221: WHERE PRIMARY_FLAG = 'Y'
4222: AND owner_table_name = 'HZ_PARTIES'
4223: AND owner_table_id = p_party_id
4224:

Line 4228: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4224:
4225: UNION
4226:
4227: SELECT CONTACT_POINT_ID
4228: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4229: WHERE PRIMARY_FLAG = 'Y'
4230: AND owner_table_name = 'HZ_PARTIES'
4231: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4232: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4240: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

4236: and l_use_contact_info = 'Y'
4237: UNION
4238:
4239: SELECT CONTACT_POINT_ID
4240: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4241: WHERE PRIMARY_FLAG = 'Y'
4242: AND owner_table_name = 'HZ_PARTY_SITES'
4243: AND owner_table_id = party_site_id
4244: AND PARTY_ID = p_party_id

Line 4506: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS

4502:
4503: -- Cursor to fetch primary contact points for party
4504: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4505: SELECT contact_point_id, contact_point_type
4506: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS
4507: FROM HZ_CONTACT_POINTS
4508: WHERE contact_point_id = cp_contact_point_id;
4509:
4510: I NUMBER;

Line 4507: FROM HZ_CONTACT_POINTS

4503: -- Cursor to fetch primary contact points for party
4504: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4505: SELECT contact_point_id, contact_point_type
4506: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS
4507: FROM HZ_CONTACT_POINTS
4508: WHERE contact_point_id = cp_contact_point_id;
4509:
4510: I NUMBER;
4511: l_contact_point_id NUMBER;