APPS.HZ_MATCH_RULE_2 dependencies on HZ_PARTY_SITES

Line 3903: where owner_table_name = 'HZ_PARTY_SITES'

3899: p_contact_ids HZ_PARTY_SEARCH.IDList;
3900: l_match_idx NUMBER;
3901: cursor get_cpts_for_party_sites is select contact_point_id
3902: from hz_contact_points
3903: where owner_table_name = 'HZ_PARTY_SITES'
3904: and primary_flag='Y'
3905: and owner_table_id = p_party_site_id;
3906: BEGIN
3907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5222: FROM HZ_PARTY_SITES

5218: l_party_id := p_party_id;
5219: FOR PARTY_SITES IN (
5220: SELECT party_site_id FROM (
5221: SELECT party_site_id,identifying_address_flag
5222: FROM HZ_PARTY_SITES
5223: WHERE party_id = p_party_id
5224: AND (status is null OR status = 'A')
5225: AND identifying_address_flag='Y'
5226: UNION

Line 5229: FROM HZ_PARTY_SITES

5225: AND identifying_address_flag='Y'
5226: UNION
5227:
5228: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5229: FROM HZ_PARTY_SITES
5230: WHERE party_id = p_party_id
5231: AND (status is null OR status = 'A')
5232: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5233: AND ROWNUM<6

Line 5237: FROM HZ_PARTY_SITES

5233: AND ROWNUM<6
5234: UNION
5235:
5236: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5237: FROM HZ_PARTY_SITES
5238: WHERE (status is null OR status = 'A')
5239: AND party_id in (
5240: SELECT party_id
5241: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5381: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5382: ) IS
5383: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5384: SELECT party_site_id
5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5388:
5389: I NUMBER;

Line 5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5382: ) IS
5383: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5384: SELECT party_site_id
5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5388:
5389: I NUMBER;
5390: J NUMBER:=1;

Line 5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

5383: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5384: SELECT party_site_id
5385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5386: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5388:
5389: I NUMBER;
5390: J NUMBER:=1;
5391: l_party_site_id NUMBER;