APPS.HZ_MATCH_RULE_40 dependencies on HZ_CONTACT_POINTS

Line 4296: from hz_contact_points

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

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

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

Line 5726: FROM HZ_CONTACT_POINTS

5722: ct := ct+1;
5723: END LOOP;
5724: FOR CONTACT_POINTS IN (
5725: SELECT CONTACT_POINT_ID
5726: FROM HZ_CONTACT_POINTS
5727: WHERE PRIMARY_FLAG = 'Y'
5728: AND owner_table_name = 'HZ_PARTIES'
5729: AND owner_table_id = p_party_id
5730:

Line 5734: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5730:
5731: UNION
5732:
5733: SELECT CONTACT_POINT_ID
5734: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5735: WHERE PRIMARY_FLAG = 'Y'
5736: AND owner_table_name = 'HZ_PARTIES'
5737: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5738: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5747: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5743: AND ROWNUM<6
5744: UNION
5745:
5746: SELECT CONTACT_POINT_ID
5747: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5748: WHERE PRIMARY_FLAG = 'Y'
5749: AND owner_table_name = 'HZ_PARTY_SITES'
5750: AND owner_table_id = party_site_id
5751: AND PARTY_ID = p_party_id

Line 6015: FROM HZ_CONTACT_POINTS

6011:
6012: -- Cursor to fetch primary contact points for party
6013: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6014: SELECT contact_point_id, contact_point_type
6015: FROM HZ_CONTACT_POINTS
6016: WHERE contact_point_id = cp_contact_point_id;
6017:
6018: I NUMBER;
6019: l_contact_point_id NUMBER;