DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_6 dependencies on HZ_CONTACT_POINTS

Line 4243: from hz_contact_points

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

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

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

Line 5676: FROM HZ_CONTACT_POINTS

5672: ct := ct+1;
5673: END LOOP;
5674: FOR CONTACT_POINTS IN (
5675: SELECT CONTACT_POINT_ID
5676: FROM HZ_CONTACT_POINTS
5677: WHERE PRIMARY_FLAG = 'Y'
5678: AND owner_table_name = 'HZ_PARTIES'
5679: AND owner_table_id = p_party_id
5680:

Line 5684: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5680:
5681: UNION
5682:
5683: SELECT CONTACT_POINT_ID
5684: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5685: WHERE PRIMARY_FLAG = 'Y'
5686: AND owner_table_name = 'HZ_PARTIES'
5687: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5688: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5697: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5693: AND ROWNUM<6
5694: UNION
5695:
5696: SELECT CONTACT_POINT_ID
5697: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5698: WHERE PRIMARY_FLAG = 'Y'
5699: AND owner_table_name = 'HZ_PARTY_SITES'
5700: AND owner_table_id = party_site_id
5701: AND PARTY_ID = p_party_id

Line 5965: FROM HZ_CONTACT_POINTS

5961:
5962: -- Cursor to fetch primary contact points for party
5963: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5964: SELECT contact_point_id, contact_point_type
5965: FROM HZ_CONTACT_POINTS
5966: WHERE contact_point_id = cp_contact_point_id;
5967:
5968: I NUMBER;
5969: l_contact_point_id NUMBER;