APPS.HZ_MATCH_RULE_6 dependencies on HZ_CONTACT_POINTS

Line 4247: from hz_contact_points

4243: p_party_site_list HZ_PARTY_SEARCH.IDList;
4244: p_contact_ids HZ_PARTY_SEARCH.IDList;
4245: l_match_idx NUMBER;
4246: cursor get_cpts_for_party_sites is select contact_point_id
4247: from hz_contact_points
4248: where owner_table_name = 'HZ_PARTY_SITES'
4249: and primary_flag='Y'
4250: and owner_table_id = p_party_site_id;
4251: BEGIN

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

4328: p_party_site_list HZ_PARTY_SEARCH.IDList;
4329: p_contact_ids HZ_PARTY_SEARCH.IDList;
4330: l_match_idx NUMBER;
4331: cursor get_cpt_for_contact_id is select contact_point_id
4332: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4333: where a.party_relationship_id = b.relationship_id
4334: and c.owner_table_name = 'HZ_PARTIES'
4335: and c.primary_flag='Y'
4336: and c.owner_table_id = b.party_id

Line 5681: FROM HZ_CONTACT_POINTS

5677: ct := ct+1;
5678: END LOOP;
5679: FOR CONTACT_POINTS IN (
5680: SELECT CONTACT_POINT_ID
5681: FROM HZ_CONTACT_POINTS
5682: WHERE PRIMARY_FLAG = 'Y'
5683: AND owner_table_name = 'HZ_PARTIES'
5684: AND owner_table_id = p_party_id
5685:

Line 5689: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5685:
5686: UNION
5687:
5688: SELECT CONTACT_POINT_ID
5689: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5690: WHERE PRIMARY_FLAG = 'Y'
5691: AND owner_table_name = 'HZ_PARTIES'
5692: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5693: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5702: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5698: AND ROWNUM<6
5699: UNION
5700:
5701: SELECT CONTACT_POINT_ID
5702: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5703: WHERE PRIMARY_FLAG = 'Y'
5704: AND owner_table_name = 'HZ_PARTY_SITES'
5705: AND owner_table_id = party_site_id
5706: AND PARTY_ID = p_party_id

Line 5970: FROM HZ_CONTACT_POINTS

5966:
5967: -- Cursor to fetch primary contact points for party
5968: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5969: SELECT contact_point_id, contact_point_type
5970: FROM HZ_CONTACT_POINTS
5971: WHERE contact_point_id = cp_contact_point_id;
5972:
5973: I NUMBER;
5974: l_contact_point_id NUMBER;