APPS.HZ_MATCH_RULE_62 dependencies on HZ_CONTACT_POINTS

Line 565: FROM HZ_CONTACT_POINTS

561: END IF;
562: IF p_attribute = 'URL' THEN
563: BEGIN
564: SELECT URL INTO l_matched_value
565: FROM HZ_CONTACT_POINTS
566: WHERE contact_point_id = p_record_id and rownum=1;
567: EXCEPTION
568: WHEN NO_DATA_FOUND THEN
569: l_matched_value := 'Err';

Line 4746: from hz_contact_points

4742: p_party_site_list HZ_PARTY_SEARCH.IDList;
4743: p_contact_ids HZ_PARTY_SEARCH.IDList;
4744: l_match_idx NUMBER;
4745: cursor get_cpts_for_party_sites is select contact_point_id
4746: from hz_contact_points
4747: where owner_table_name = 'HZ_PARTY_SITES'
4748: and primary_flag='Y'
4749: and owner_table_id = p_party_site_id;
4750: BEGIN

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

4827: p_party_site_list HZ_PARTY_SEARCH.IDList;
4828: p_contact_ids HZ_PARTY_SEARCH.IDList;
4829: l_match_idx NUMBER;
4830: cursor get_cpt_for_contact_id is select contact_point_id
4831: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4832: where a.party_relationship_id = b.relationship_id
4833: and c.owner_table_name = 'HZ_PARTIES'
4834: and c.primary_flag='Y'
4835: and c.owner_table_id = b.party_id

Line 6253: FROM HZ_CONTACT_POINTS

6249: ps:=ps+1;
6250: END LOOP;
6251: FOR CONTACT_POINTS IN (
6252: SELECT CONTACT_POINT_ID
6253: FROM HZ_CONTACT_POINTS
6254: WHERE PRIMARY_FLAG = 'Y'
6255: AND owner_table_name = 'HZ_PARTIES'
6256: AND owner_table_id = p_party_id
6257:

Line 6261: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6257:
6258: UNION
6259:
6260: SELECT CONTACT_POINT_ID
6261: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6262: WHERE PRIMARY_FLAG = 'Y'
6263: AND owner_table_name = 'HZ_PARTIES'
6264: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6265: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6274: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6270: AND ROWNUM<6
6271: UNION
6272:
6273: SELECT CONTACT_POINT_ID
6274: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6275: WHERE PRIMARY_FLAG = 'Y'
6276: AND owner_table_name = 'HZ_PARTY_SITES'
6277: AND owner_table_id = party_site_id
6278: AND PARTY_ID = p_party_id

Line 6544: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')

6540:
6541: -- Cursor to fetch primary contact points for party
6542: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6543: SELECT contact_point_id, contact_point_type
6544: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6545: FROM HZ_CONTACT_POINTS
6546: WHERE contact_point_id = cp_contact_point_id;
6547:
6548: I NUMBER;

Line 6545: FROM HZ_CONTACT_POINTS

6541: -- Cursor to fetch primary contact points for party
6542: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6543: SELECT contact_point_id, contact_point_type
6544: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6545: FROM HZ_CONTACT_POINTS
6546: WHERE contact_point_id = cp_contact_point_id;
6547:
6548: I NUMBER;
6549: l_contact_point_id NUMBER;