APPS.HZ_MATCH_RULE_240 dependencies on HZ_LOCATIONS

Line 319: SELECT HZ_LOCATIONS.POSTAL_CODE

315: RETURN l_matched_value;
316: END IF;
317: IF p_attribute = 'POSTAL_CODE' THEN
318: BEGIN
319: SELECT HZ_LOCATIONS.POSTAL_CODE
320: INTO l_matched_value
321: FROM HZ_PARTY_SITES, HZ_LOCATIONS
322: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
323: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 321: FROM HZ_PARTY_SITES, HZ_LOCATIONS

317: IF p_attribute = 'POSTAL_CODE' THEN
318: BEGIN
319: SELECT HZ_LOCATIONS.POSTAL_CODE
320: INTO l_matched_value
321: FROM HZ_PARTY_SITES, HZ_LOCATIONS
322: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
323: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN

Line 323: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

319: SELECT HZ_LOCATIONS.POSTAL_CODE
320: INTO l_matched_value
321: FROM HZ_PARTY_SITES, HZ_LOCATIONS
322: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
323: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: l_matched_value := 'Err';
327: END;

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

5619: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5620: ) IS
5621: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5622: SELECT party_site_id
5623: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5624: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5625: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5626: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5627:

Line 5624: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5620: ) IS
5621: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5622: SELECT party_site_id
5623: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5624: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5625: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5626: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5627:
5628: I NUMBER;

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

5622: SELECT party_site_id
5623: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5624: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5625: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5626: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5627:
5628: I NUMBER;
5629: J NUMBER:=1;
5630: l_party_site_id NUMBER;