APPS.HZ_MATCH_RULE_50 dependencies on HZ_CONTACT_POINTS

Line 500: FROM HZ_CONTACT_POINTS

496: IF p_entity = 'CONTACT_POINTS' THEN
497: IF p_attribute = 'URL' THEN
498: BEGIN
499: SELECT URL INTO l_matched_value
500: FROM HZ_CONTACT_POINTS
501: WHERE contact_point_id = p_record_id and rownum=1;
502: EXCEPTION
503: WHEN NO_DATA_FOUND THEN
504: l_matched_value := 'Err';

Line 3046: from hz_contact_points

3042: p_party_site_list HZ_PARTY_SEARCH.IDList;
3043: p_contact_ids HZ_PARTY_SEARCH.IDList;
3044: l_match_idx NUMBER;
3045: cursor get_cpts_for_party_sites is select contact_point_id
3046: from hz_contact_points
3047: where owner_table_name = 'HZ_PARTY_SITES'
3048: and primary_flag='Y'
3049: and owner_table_id = p_party_site_id;
3050: BEGIN

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

3130: p_party_site_list HZ_PARTY_SEARCH.IDList;
3131: p_contact_ids HZ_PARTY_SEARCH.IDList;
3132: l_match_idx NUMBER;
3133: cursor get_cpt_for_contact_id is select contact_point_id
3134: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3135: where a.party_relationship_id = b.relationship_id
3136: and c.owner_table_name = 'HZ_PARTIES'
3137: and c.primary_flag='Y'
3138: and c.owner_table_id = b.party_id

Line 4546: FROM HZ_CONTACT_POINTS

4542: ct := ct+1;
4543: END LOOP;
4544: FOR CONTACT_POINTS IN (
4545: SELECT CONTACT_POINT_ID
4546: FROM HZ_CONTACT_POINTS
4547: WHERE PRIMARY_FLAG = 'Y'
4548: AND owner_table_name = 'HZ_PARTIES'
4549: AND owner_table_id = p_party_id
4550:

Line 4554: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4550:
4551: UNION
4552:
4553: SELECT CONTACT_POINT_ID
4554: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4555: WHERE PRIMARY_FLAG = 'Y'
4556: AND owner_table_name = 'HZ_PARTIES'
4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4566: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

4562: and l_use_contact_info = 'Y'
4563: UNION
4564:
4565: SELECT CONTACT_POINT_ID
4566: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4567: WHERE PRIMARY_FLAG = 'Y'
4568: AND owner_table_name = 'HZ_PARTY_SITES'
4569: AND owner_table_id = party_site_id
4570: AND PARTY_ID = p_party_id

Line 4846: ,HZ_CONTACT_POINTS.URL

4842:
4843: -- Cursor to fetch primary contact points for party
4844: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4845: SELECT contact_point_id, contact_point_type
4846: ,HZ_CONTACT_POINTS.URL
4847: FROM HZ_CONTACT_POINTS
4848: WHERE contact_point_id = cp_contact_point_id;
4849:
4850: I NUMBER;

Line 4847: FROM HZ_CONTACT_POINTS

4843: -- Cursor to fetch primary contact points for party
4844: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
4845: SELECT contact_point_id, contact_point_type
4846: ,HZ_CONTACT_POINTS.URL
4847: FROM HZ_CONTACT_POINTS
4848: WHERE contact_point_id = cp_contact_point_id;
4849:
4850: I NUMBER;
4851: l_contact_point_id NUMBER;