APPS.HZ_MATCH_RULE_5 dependencies on HZ_PARTY_SITES

Line 3803: where owner_table_name = 'HZ_PARTY_SITES'

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

Line 5118: FROM HZ_PARTY_SITES

5114: l_party_id := p_party_id;
5115: FOR PARTY_SITES IN (
5116: SELECT party_site_id FROM (
5117: SELECT party_site_id,identifying_address_flag
5118: FROM HZ_PARTY_SITES
5119: WHERE party_id = p_party_id
5120: AND (status is null OR status = 'A')
5121: AND identifying_address_flag='Y'
5122: UNION

Line 5125: FROM HZ_PARTY_SITES

5121: AND identifying_address_flag='Y'
5122: UNION
5123:
5124: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5125: FROM HZ_PARTY_SITES
5126: WHERE party_id = p_party_id
5127: AND (status is null OR status = 'A')
5128: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5129: AND ROWNUM<6

Line 5133: FROM HZ_PARTY_SITES

5129: AND ROWNUM<6
5130: UNION
5131:
5132: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5133: FROM HZ_PARTY_SITES
5134: WHERE (status is null OR status = 'A')
5135: AND party_id in (
5136: SELECT party_id
5137: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5278: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5274: ) IS
5275: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5276: SELECT party_site_id
5277: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5278: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5279: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5280: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5281:
5282: I NUMBER;

Line 5279: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5275: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5276: SELECT party_site_id
5277: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5278: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5279: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5280: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5281:
5282: I NUMBER;
5283: J NUMBER:=1;

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

5276: SELECT party_site_id
5277: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5278: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5279: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5280: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5281:
5282: I NUMBER;
5283: J NUMBER:=1;
5284: l_party_site_id NUMBER;