APPS.HZ_MATCH_RULE_52 dependencies on HZ_CONTACT_POINTS

Line 509: FROM HZ_CONTACT_POINTS

505: IF p_entity = 'CONTACT_POINTS' THEN
506: IF p_attribute = 'EMAIL_ADDRESS' THEN
507: BEGIN
508: SELECT EMAIL_ADDRESS INTO l_matched_value
509: FROM HZ_CONTACT_POINTS
510: WHERE contact_point_id = p_record_id and rownum=1;
511: EXCEPTION
512: WHEN NO_DATA_FOUND THEN
513: l_matched_value := 'Err';

Line 520: FROM HZ_CONTACT_POINTS

516: END IF;
517: IF p_attribute = 'URL' THEN
518: BEGIN
519: SELECT URL INTO l_matched_value
520: FROM HZ_CONTACT_POINTS
521: WHERE contact_point_id = p_record_id and rownum=1;
522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
524: l_matched_value := 'Err';

Line 3114: from hz_contact_points

3110: p_party_site_list HZ_PARTY_SEARCH.IDList;
3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;
3113: cursor get_cpts_for_party_sites is select contact_point_id
3114: from hz_contact_points
3115: where owner_table_name = 'HZ_PARTY_SITES'
3116: and primary_flag='Y'
3117: and owner_table_id = p_party_site_id;
3118: BEGIN

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

3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;
3201: cursor get_cpt_for_contact_id is select contact_point_id
3202: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3203: where a.party_relationship_id = b.relationship_id
3204: and c.owner_table_name = 'HZ_PARTIES'
3205: and c.primary_flag='Y'
3206: and c.owner_table_id = b.party_id

Line 4644: FROM HZ_CONTACT_POINTS

4640: ct := ct+1;
4641: END LOOP;
4642: FOR CONTACT_POINTS IN (
4643: SELECT CONTACT_POINT_ID
4644: FROM HZ_CONTACT_POINTS
4645: WHERE PRIMARY_FLAG = 'Y'
4646: AND owner_table_name = 'HZ_PARTIES'
4647: AND owner_table_id = p_party_id
4648:

Line 4652: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4648:
4649: UNION
4650:
4651: SELECT CONTACT_POINT_ID
4652: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4653: WHERE PRIMARY_FLAG = 'Y'
4654: AND owner_table_name = 'HZ_PARTIES'
4655: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4656: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4664: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

4660: and l_use_contact_info = 'Y'
4661: UNION
4662:
4663: SELECT CONTACT_POINT_ID
4664: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4665: WHERE PRIMARY_FLAG = 'Y'
4666: AND owner_table_name = 'HZ_PARTY_SITES'
4667: AND owner_table_id = party_site_id
4668: AND PARTY_ID = p_party_id

Line 4944: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS

4940:
4941: -- Cursor to fetch primary contact points for party
4942: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4943: SELECT contact_point_id, contact_point_type
4944: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS
4945: ,HZ_CONTACT_POINTS.URL
4946: FROM HZ_CONTACT_POINTS
4947: WHERE contact_point_id = cp_contact_point_id;
4948:

Line 4945: ,HZ_CONTACT_POINTS.URL

4941: -- Cursor to fetch primary contact points for party
4942: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4943: SELECT contact_point_id, contact_point_type
4944: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS
4945: ,HZ_CONTACT_POINTS.URL
4946: FROM HZ_CONTACT_POINTS
4947: WHERE contact_point_id = cp_contact_point_id;
4948:
4949: I NUMBER;

Line 4946: FROM HZ_CONTACT_POINTS

4942: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4943: SELECT contact_point_id, contact_point_type
4944: ,HZ_CONTACT_POINTS.EMAIL_ADDRESS
4945: ,HZ_CONTACT_POINTS.URL
4946: FROM HZ_CONTACT_POINTS
4947: WHERE contact_point_id = cp_contact_point_id;
4948:
4949: I NUMBER;
4950: l_contact_point_id NUMBER;