APPS.HZ_MATCH_RULE_2 dependencies on HZ_PARTY_SITES

Line 3907: where owner_table_name = 'HZ_PARTY_SITES'

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

Line 5227: FROM HZ_PARTY_SITES

5223: l_party_id := p_party_id;
5224: FOR PARTY_SITES IN (
5225: SELECT party_site_id FROM (
5226: SELECT party_site_id,identifying_address_flag
5227: FROM HZ_PARTY_SITES
5228: WHERE party_id = p_party_id
5229: AND (status is null OR status = 'A')
5230: AND identifying_address_flag='Y'
5231: UNION

Line 5234: FROM HZ_PARTY_SITES

5230: AND identifying_address_flag='Y'
5231: UNION
5232:
5233: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5234: FROM HZ_PARTY_SITES
5235: WHERE party_id = p_party_id
5236: AND (status is null OR status = 'A')
5237: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5238: AND ROWNUM<6

Line 5242: FROM HZ_PARTY_SITES

5238: AND ROWNUM<6
5239: UNION
5240:
5241: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5242: FROM HZ_PARTY_SITES
5243: WHERE (status is null OR status = 'A')
5244: AND party_id in (
5245: SELECT party_id
5246: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5390: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5386: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5387: ) IS
5388: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5389: SELECT party_site_id
5390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5393:
5394: I NUMBER;

Line 5391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5387: ) IS
5388: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5389: SELECT party_site_id
5390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5393:
5394: I NUMBER;
5395: J NUMBER:=1;

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

5388: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5389: SELECT party_site_id
5390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5393:
5394: I NUMBER;
5395: J NUMBER:=1;
5396: l_party_site_id NUMBER;