APPS.HZ_MATCH_RULE_33 dependencies on HZ_CONTACT_POINTS

Line 542: FROM HZ_CONTACT_POINTS

538: END IF;
539: IF p_attribute = 'EMAIL_ADDRESS' THEN
540: BEGIN
541: SELECT EMAIL_ADDRESS INTO l_matched_value
542: FROM HZ_CONTACT_POINTS
543: WHERE contact_point_id = p_record_id and rownum=1;
544: EXCEPTION
545: WHEN NO_DATA_FOUND THEN
546: l_matched_value := 'Err';

Line 4710: from hz_contact_points

4706: p_party_site_list HZ_PARTY_SEARCH.IDList;
4707: p_contact_ids HZ_PARTY_SEARCH.IDList;
4708: l_match_idx NUMBER;
4709: cursor get_cpts_for_party_sites is select contact_point_id
4710: from hz_contact_points
4711: where owner_table_name = 'HZ_PARTY_SITES'
4712: and primary_flag='Y'
4713: and owner_table_id = p_party_site_id;
4714: BEGIN

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

4791: p_party_site_list HZ_PARTY_SEARCH.IDList;
4792: p_contact_ids HZ_PARTY_SEARCH.IDList;
4793: l_match_idx NUMBER;
4794: cursor get_cpt_for_contact_id is select contact_point_id
4795: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4796: where a.party_relationship_id = b.relationship_id
4797: and c.owner_table_name = 'HZ_PARTIES'
4798: and c.primary_flag='Y'
4799: and c.owner_table_id = b.party_id

Line 6225: FROM HZ_CONTACT_POINTS

6221: ct := ct+1;
6222: END LOOP;
6223: FOR CONTACT_POINTS IN (
6224: SELECT CONTACT_POINT_ID
6225: FROM HZ_CONTACT_POINTS
6226: WHERE PRIMARY_FLAG = 'Y'
6227: AND owner_table_name = 'HZ_PARTIES'
6228: AND owner_table_id = p_party_id
6229:

Line 6233: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6229:
6230: UNION
6231:
6232: SELECT CONTACT_POINT_ID
6233: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6234: WHERE PRIMARY_FLAG = 'Y'
6235: AND owner_table_name = 'HZ_PARTIES'
6236: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6237: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6246: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6242: AND ROWNUM<6
6243: UNION
6244:
6245: SELECT CONTACT_POINT_ID
6246: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6247: WHERE PRIMARY_FLAG = 'Y'
6248: AND owner_table_name = 'HZ_PARTY_SITES'
6249: AND owner_table_id = party_site_id
6250: AND PARTY_ID = p_party_id

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

6516:
6517: -- Cursor to fetch primary contact points for party
6518: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6519: SELECT contact_point_id, contact_point_type
6520: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6521: FROM HZ_CONTACT_POINTS
6522: WHERE contact_point_id = cp_contact_point_id;
6523:
6524: I NUMBER;

Line 6521: FROM HZ_CONTACT_POINTS

6517: -- Cursor to fetch primary contact points for party
6518: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6519: SELECT contact_point_id, contact_point_type
6520: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6521: FROM HZ_CONTACT_POINTS
6522: WHERE contact_point_id = cp_contact_point_id;
6523:
6524: I NUMBER;
6525: l_contact_point_id NUMBER;