APPS.HZ_MATCH_RULE_36 dependencies on HZ_CONTACT_POINTS

Line 4433: from hz_contact_points

4429: p_party_site_list HZ_PARTY_SEARCH.IDList;
4430: p_contact_ids HZ_PARTY_SEARCH.IDList;
4431: l_match_idx NUMBER;
4432: cursor get_cpts_for_party_sites is select contact_point_id
4433: from hz_contact_points
4434: where owner_table_name = 'HZ_PARTY_SITES'
4435: and primary_flag='Y'
4436: and owner_table_id = p_party_site_id;
4437: BEGIN

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

4514: p_party_site_list HZ_PARTY_SEARCH.IDList;
4515: p_contact_ids HZ_PARTY_SEARCH.IDList;
4516: l_match_idx NUMBER;
4517: cursor get_cpt_for_contact_id is select contact_point_id
4518: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4519: where a.party_relationship_id = b.relationship_id
4520: and c.owner_table_name = 'HZ_PARTIES'
4521: and c.primary_flag='Y'
4522: and c.owner_table_id = b.party_id

Line 6118: FROM HZ_CONTACT_POINTS

6114:
6115: -- Cursor to fetch primary contact points for party
6116: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6117: SELECT contact_point_id, contact_point_type
6118: FROM HZ_CONTACT_POINTS
6119: WHERE contact_point_id = cp_contact_point_id;
6120:
6121: I NUMBER;
6122: l_contact_point_id NUMBER;