APPS.HZ_MATCH_RULE_61 dependencies on HZ_CONTACT_POINTS

Line 404: FROM HZ_CONTACT_POINTS

400: IF p_entity = 'CONTACT_POINTS' THEN
401: IF p_attribute = 'URL' THEN
402: BEGIN
403: SELECT URL INTO l_matched_value
404: FROM HZ_CONTACT_POINTS
405: WHERE contact_point_id = p_record_id and rownum=1;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: l_matched_value := 'Err';

Line 4221: from hz_contact_points

4217: p_party_site_list HZ_PARTY_SEARCH.IDList;
4218: p_contact_ids HZ_PARTY_SEARCH.IDList;
4219: l_match_idx NUMBER;
4220: cursor get_cpts_for_party_sites is select contact_point_id
4221: from hz_contact_points
4222: where owner_table_name = 'HZ_PARTY_SITES'
4223: and primary_flag='Y'
4224: and owner_table_id = p_party_site_id;
4225: BEGIN

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

4302: p_party_site_list HZ_PARTY_SEARCH.IDList;
4303: p_contact_ids HZ_PARTY_SEARCH.IDList;
4304: l_match_idx NUMBER;
4305: cursor get_cpt_for_contact_id is select contact_point_id
4306: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4307: where a.party_relationship_id = b.relationship_id
4308: and c.owner_table_name = 'HZ_PARTIES'
4309: and c.primary_flag='Y'
4310: and c.owner_table_id = b.party_id

Line 5578: FROM HZ_CONTACT_POINTS

5574: END IF;
5575: l_party_id := p_party_id;
5576: FOR CONTACT_POINTS IN (
5577: SELECT CONTACT_POINT_ID
5578: FROM HZ_CONTACT_POINTS
5579: WHERE PRIMARY_FLAG = 'Y'
5580: AND owner_table_name = 'HZ_PARTIES'
5581: AND owner_table_id = p_party_id
5582:

Line 5586: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5582:
5583: UNION
5584:
5585: SELECT CONTACT_POINT_ID
5586: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5587: WHERE PRIMARY_FLAG = 'Y'
5588: AND owner_table_name = 'HZ_PARTIES'
5589: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5590: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5599: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5595: AND ROWNUM<6
5596: UNION
5597:
5598: SELECT CONTACT_POINT_ID
5599: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5600: WHERE PRIMARY_FLAG = 'Y'
5601: AND owner_table_name = 'HZ_PARTY_SITES'
5602: AND owner_table_id = party_site_id
5603: AND PARTY_ID = p_party_id

Line 5851: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')

5847:
5848: -- Cursor to fetch primary contact points for party
5849: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5850: SELECT contact_point_id, contact_point_type
5851: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
5852: FROM HZ_CONTACT_POINTS
5853: WHERE contact_point_id = cp_contact_point_id;
5854:
5855: I NUMBER;

Line 5852: FROM HZ_CONTACT_POINTS

5848: -- Cursor to fetch primary contact points for party
5849: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5850: SELECT contact_point_id, contact_point_type
5851: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
5852: FROM HZ_CONTACT_POINTS
5853: WHERE contact_point_id = cp_contact_point_id;
5854:
5855: I NUMBER;
5856: l_contact_point_id NUMBER;