APPS.HZ_MATCH_RULE_40 dependencies on HZ_CONTACT_POINTS

Line 4292: from hz_contact_points

4288: p_party_site_list HZ_PARTY_SEARCH.IDList;
4289: p_contact_ids HZ_PARTY_SEARCH.IDList;
4290: l_match_idx NUMBER;
4291: cursor get_cpts_for_party_sites is select contact_point_id
4292: from hz_contact_points
4293: where owner_table_name = 'HZ_PARTY_SITES'
4294: and primary_flag='Y'
4295: and owner_table_id = p_party_site_id;
4296: BEGIN

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

4373: p_party_site_list HZ_PARTY_SEARCH.IDList;
4374: p_contact_ids HZ_PARTY_SEARCH.IDList;
4375: l_match_idx NUMBER;
4376: cursor get_cpt_for_contact_id is select contact_point_id
4377: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4378: where a.party_relationship_id = b.relationship_id
4379: and c.owner_table_name = 'HZ_PARTIES'
4380: and c.primary_flag='Y'
4381: and c.owner_table_id = b.party_id

Line 5721: FROM HZ_CONTACT_POINTS

5717: ct := ct+1;
5718: END LOOP;
5719: FOR CONTACT_POINTS IN (
5720: SELECT CONTACT_POINT_ID
5721: FROM HZ_CONTACT_POINTS
5722: WHERE PRIMARY_FLAG = 'Y'
5723: AND owner_table_name = 'HZ_PARTIES'
5724: AND owner_table_id = p_party_id
5725:

Line 5729: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5725:
5726: UNION
5727:
5728: SELECT CONTACT_POINT_ID
5729: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5730: WHERE PRIMARY_FLAG = 'Y'
5731: AND owner_table_name = 'HZ_PARTIES'
5732: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5733: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5742: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5738: AND ROWNUM<6
5739: UNION
5740:
5741: SELECT CONTACT_POINT_ID
5742: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5743: WHERE PRIMARY_FLAG = 'Y'
5744: AND owner_table_name = 'HZ_PARTY_SITES'
5745: AND owner_table_id = party_site_id
5746: AND PARTY_ID = p_party_id

Line 6010: FROM HZ_CONTACT_POINTS

6006:
6007: -- Cursor to fetch primary contact points for party
6008: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6009: SELECT contact_point_id, contact_point_type
6010: FROM HZ_CONTACT_POINTS
6011: WHERE contact_point_id = cp_contact_point_id;
6012:
6013: I NUMBER;
6014: l_contact_point_id NUMBER;