APPS.HZ_MATCH_RULE_40 dependencies on HZ_LOCATIONS

Line 390: SELECT HZ_LOCATIONS.POSTAL_CODE

386: RETURN l_matched_value;
387: END IF;
388: IF p_attribute = 'POSTAL_CODE' THEN
389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 392: FROM HZ_PARTY_SITES, HZ_LOCATIONS

388: IF p_attribute = 'POSTAL_CODE' THEN
389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN

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

390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: l_matched_value := 'Err';
398: END;

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

5895: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5896: ) IS
5897: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:

Line 5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5896: ) IS
5897: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:
5904: I NUMBER;

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

5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:
5904: I NUMBER;
5905: J NUMBER:=1;
5906: l_party_site_id NUMBER;