APPS.HZ_MATCH_RULE_240 dependencies on HZ_PARTY_SITES

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 322: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
326: l_matched_value := 'Err';

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 4066: where owner_table_name = 'HZ_PARTY_SITES'

4062: p_contact_ids HZ_PARTY_SEARCH.IDList;
4063: l_match_idx NUMBER;
4064: cursor get_cpts_for_party_sites is select contact_point_id
4065: from hz_contact_points
4066: where owner_table_name = 'HZ_PARTY_SITES'
4067: and primary_flag='Y'
4068: and owner_table_id = p_party_site_id;
4069: BEGIN
4070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5430: FROM HZ_PARTY_SITES

5426: l_party_id := p_party_id;
5427: FOR PARTY_SITES IN (
5428: SELECT party_site_id FROM (
5429: SELECT party_site_id,identifying_address_flag
5430: FROM HZ_PARTY_SITES
5431: WHERE party_id = p_party_id
5432: AND (status is null OR status = 'A')
5433: AND identifying_address_flag='Y'
5434: UNION

Line 5437: FROM HZ_PARTY_SITES

5433: AND identifying_address_flag='Y'
5434: UNION
5435:
5436: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5437: FROM HZ_PARTY_SITES
5438: WHERE party_id = p_party_id
5439: AND (status is null OR status = 'A')
5440: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5441: AND ROWNUM<6

Line 5445: FROM HZ_PARTY_SITES

5441: AND ROWNUM<6
5442: UNION
5443:
5444: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5445: FROM HZ_PARTY_SITES
5446: WHERE (status is null OR status = 'A')
5447: AND party_id in (
5448: SELECT party_id
5449: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5485: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5481: AND ROWNUM<6
5482: UNION
5483:
5484: SELECT CONTACT_POINT_ID
5485: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5486: WHERE PRIMARY_FLAG = 'Y'
5487: AND owner_table_name = 'HZ_PARTY_SITES'
5488: AND owner_table_id = party_site_id
5489: AND PARTY_ID = p_party_id

Line 5487: AND owner_table_name = 'HZ_PARTY_SITES'

5483:
5484: SELECT CONTACT_POINT_ID
5485: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5486: WHERE PRIMARY_FLAG = 'Y'
5487: AND owner_table_name = 'HZ_PARTY_SITES'
5488: AND owner_table_id = party_site_id
5489: AND PARTY_ID = p_party_id
5490: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5491: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

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 5625: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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;
5629: J NUMBER:=1;

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;