APPS.HZ_MATCH_RULE_60 dependencies on HZ_CONTACT_POINTS

Line 562: FROM HZ_CONTACT_POINTS

558: END IF;
559: IF p_attribute = 'EMAIL_ADDRESS' THEN
560: BEGIN
561: SELECT EMAIL_ADDRESS INTO l_matched_value
562: FROM HZ_CONTACT_POINTS
563: WHERE contact_point_id = p_record_id and rownum=1;
564: EXCEPTION
565: WHEN NO_DATA_FOUND THEN
566: l_matched_value := 'Err';

Line 4741: from hz_contact_points

4737: p_party_site_list HZ_PARTY_SEARCH.IDList;
4738: p_contact_ids HZ_PARTY_SEARCH.IDList;
4739: l_match_idx NUMBER;
4740: cursor get_cpts_for_party_sites is select contact_point_id
4741: from hz_contact_points
4742: where owner_table_name = 'HZ_PARTY_SITES'
4743: and primary_flag='Y'
4744: and owner_table_id = p_party_site_id;
4745: BEGIN

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

4822: p_party_site_list HZ_PARTY_SEARCH.IDList;
4823: p_contact_ids HZ_PARTY_SEARCH.IDList;
4824: l_match_idx NUMBER;
4825: cursor get_cpt_for_contact_id is select contact_point_id
4826: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4827: where a.party_relationship_id = b.relationship_id
4828: and c.owner_table_name = 'HZ_PARTIES'
4829: and c.primary_flag='Y'
4830: and c.owner_table_id = b.party_id

Line 6258: FROM HZ_CONTACT_POINTS

6254: ct := ct+1;
6255: END LOOP;
6256: FOR CONTACT_POINTS IN (
6257: SELECT CONTACT_POINT_ID
6258: FROM HZ_CONTACT_POINTS
6259: WHERE PRIMARY_FLAG = 'Y'
6260: AND owner_table_name = 'HZ_PARTIES'
6261: AND owner_table_id = p_party_id
6262:

Line 6266: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6262:
6263: UNION
6264:
6265: SELECT CONTACT_POINT_ID
6266: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6267: WHERE PRIMARY_FLAG = 'Y'
6268: AND owner_table_name = 'HZ_PARTIES'
6269: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6270: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6279: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6275: AND ROWNUM<6
6276: UNION
6277:
6278: SELECT CONTACT_POINT_ID
6279: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6280: WHERE PRIMARY_FLAG = 'Y'
6281: AND owner_table_name = 'HZ_PARTY_SITES'
6282: AND owner_table_id = party_site_id
6283: AND PARTY_ID = p_party_id

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

6551:
6552: -- Cursor to fetch primary contact points for party
6553: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6554: SELECT contact_point_id, contact_point_type
6555: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6556: FROM HZ_CONTACT_POINTS
6557: WHERE contact_point_id = cp_contact_point_id;
6558:
6559: I NUMBER;

Line 6556: FROM HZ_CONTACT_POINTS

6552: -- Cursor to fetch primary contact points for party
6553: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6554: SELECT contact_point_id, contact_point_type
6555: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6556: FROM HZ_CONTACT_POINTS
6557: WHERE contact_point_id = cp_contact_point_id;
6558:
6559: I NUMBER;
6560: l_contact_point_id NUMBER;