APPS.HZ_MATCH_RULE_37 dependencies on HZ_CONTACT_POINTS

Line 4147: from hz_contact_points

4143: p_party_site_list HZ_PARTY_SEARCH.IDList;
4144: p_contact_ids HZ_PARTY_SEARCH.IDList;
4145: l_match_idx NUMBER;
4146: cursor get_cpts_for_party_sites is select contact_point_id
4147: from hz_contact_points
4148: where owner_table_name = 'HZ_PARTY_SITES'
4149: and primary_flag='Y'
4150: and owner_table_id = p_party_site_id;
4151: BEGIN

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

4228: p_party_site_list HZ_PARTY_SEARCH.IDList;
4229: p_contact_ids HZ_PARTY_SEARCH.IDList;
4230: l_match_idx NUMBER;
4231: cursor get_cpt_for_contact_id is select contact_point_id
4232: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4233: where a.party_relationship_id = b.relationship_id
4234: and c.owner_table_name = 'HZ_PARTIES'
4235: and c.primary_flag='Y'
4236: and c.owner_table_id = b.party_id

Line 5778: FROM HZ_CONTACT_POINTS

5774:
5775: -- Cursor to fetch primary contact points for party
5776: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5777: SELECT contact_point_id, contact_point_type
5778: FROM HZ_CONTACT_POINTS
5779: WHERE contact_point_id = cp_contact_point_id;
5780:
5781: I NUMBER;
5782: l_contact_point_id NUMBER;