APPS.HZ_MATCH_RULE_4 dependencies on HZ_PARTY_SITES

Line 3914: where owner_table_name = 'HZ_PARTY_SITES'

3910: p_contact_ids HZ_PARTY_SEARCH.IDList;
3911: l_match_idx NUMBER;
3912: cursor get_cpts_for_party_sites is select contact_point_id
3913: from hz_contact_points
3914: where owner_table_name = 'HZ_PARTY_SITES'
3915: and primary_flag='Y'
3916: and owner_table_id = p_party_site_id;
3917: BEGIN
3918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5246: FROM HZ_PARTY_SITES

5242: l_party_id := p_party_id;
5243: FOR PARTY_SITES IN (
5244: SELECT party_site_id FROM (
5245: SELECT party_site_id,identifying_address_flag
5246: FROM HZ_PARTY_SITES
5247: WHERE party_id = p_party_id
5248: AND (status is null OR status = 'A')
5249: AND identifying_address_flag='Y'
5250: UNION

Line 5253: FROM HZ_PARTY_SITES

5249: AND identifying_address_flag='Y'
5250: UNION
5251:
5252: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5253: FROM HZ_PARTY_SITES
5254: WHERE party_id = p_party_id
5255: AND (status is null OR status = 'A')
5256: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5257: AND ROWNUM<6

Line 5261: FROM HZ_PARTY_SITES

5257: AND ROWNUM<6
5258: UNION
5259:
5260: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5261: FROM HZ_PARTY_SITES
5262: WHERE (status is null OR status = 'A')
5263: AND party_id in (
5264: SELECT party_id
5265: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5412: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5408: ) IS
5409: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5410: SELECT party_site_id
5411: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5415:
5416: I NUMBER;

Line 5413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5409: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5410: SELECT party_site_id
5411: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5415:
5416: I NUMBER;
5417: J NUMBER:=1;

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

5410: SELECT party_site_id
5411: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5415:
5416: I NUMBER;
5417: J NUMBER:=1;
5418: l_party_site_id NUMBER;