APPS.HZ_MATCH_RULE_238 dependencies on HZ_LOCATIONS

Line 370: SELECT HZ_LOCATIONS.POSTAL_CODE

366: RETURN l_matched_value;
367: END IF;
368: IF p_attribute = 'POSTAL_CODE' THEN
369: BEGIN
370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 372: FROM HZ_PARTY_SITES, HZ_LOCATIONS

368: IF p_attribute = 'POSTAL_CODE' THEN
369: BEGIN
370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN

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

370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: l_matched_value := 'Err';
378: END;

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

5722: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5723: ) IS
5724: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:

Line 5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5723: ) IS
5724: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:
5731: I NUMBER;

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

5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:
5731: I NUMBER;
5732: J NUMBER:=1;
5733: l_party_site_id NUMBER;