APPS.HZ_MATCH_RULE_5 dependencies on HZ_CONTACT_POINTS

Line 3798: from hz_contact_points

3794: p_party_site_list HZ_PARTY_SEARCH.IDList;
3795: p_contact_ids HZ_PARTY_SEARCH.IDList;
3796: l_match_idx NUMBER;
3797: cursor get_cpts_for_party_sites is select contact_point_id
3798: from hz_contact_points
3799: where owner_table_name = 'HZ_PARTY_SITES'
3800: and primary_flag='Y'
3801: and owner_table_id = p_party_site_id;
3802: BEGIN

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

3879: p_party_site_list HZ_PARTY_SEARCH.IDList;
3880: p_contact_ids HZ_PARTY_SEARCH.IDList;
3881: l_match_idx NUMBER;
3882: cursor get_cpt_for_contact_id is select contact_point_id
3883: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3884: where a.party_relationship_id = b.relationship_id
3885: and c.owner_table_name = 'HZ_PARTIES'
3886: and c.primary_flag='Y'
3887: and c.owner_table_id = b.party_id

Line 5386: FROM HZ_CONTACT_POINTS

5382:
5383: -- Cursor to fetch primary contact points for party
5384: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5385: SELECT contact_point_id, contact_point_type
5386: FROM HZ_CONTACT_POINTS
5387: WHERE contact_point_id = cp_contact_point_id;
5388:
5389: I NUMBER;
5390: l_contact_point_id NUMBER;