APPS.HZ_MATCH_RULE_5 dependencies on HZ_LOCATIONS

Line 5277: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')

5273: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
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:

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 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;