APPS.HZ_MATCH_RULE_5 dependencies on HZ_PARTY_SITES

Line 3799: where owner_table_name = 'HZ_PARTY_SITES'

3795: p_contact_ids HZ_PARTY_SEARCH.IDList;
3796: l_match_idx NUMBER;
3797: cursor get_cpts_for_party_sites is select contact_point_id
3798: from hz_contact_points
3799: where owner_table_name = 'HZ_PARTY_SITES'
3800: and primary_flag='Y'
3801: and owner_table_id = p_party_site_id;
3802: BEGIN
3803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5113: FROM HZ_PARTY_SITES

5109: l_party_id := p_party_id;
5110: FOR PARTY_SITES IN (
5111: SELECT party_site_id FROM (
5112: SELECT party_site_id,identifying_address_flag
5113: FROM HZ_PARTY_SITES
5114: WHERE party_id = p_party_id
5115: AND (status is null OR status = 'A')
5116: AND identifying_address_flag='Y'
5117: UNION

Line 5120: FROM HZ_PARTY_SITES

5116: AND identifying_address_flag='Y'
5117: UNION
5118:
5119: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5120: FROM HZ_PARTY_SITES
5121: WHERE party_id = p_party_id
5122: AND (status is null OR status = 'A')
5123: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5124: AND ROWNUM<6

Line 5128: FROM HZ_PARTY_SITES

5124: AND ROWNUM<6
5125: UNION
5126:
5127: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5128: FROM HZ_PARTY_SITES
5129: WHERE (status is null OR status = 'A')
5130: AND party_id in (
5131: SELECT party_id
5132: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5269: ) IS
5270: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5277: I NUMBER;

Line 5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5270: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5277: I NUMBER;
5278: J NUMBER:=1;

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

5271: SELECT party_site_id
5272: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5273: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5274: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5275: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5276:
5277: I NUMBER;
5278: J NUMBER:=1;
5279: l_party_site_id NUMBER;