APPS.HZ_MATCH_RULE_41 dependencies on HZ_PARTY_SITES

Line 376: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 377: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 4184: where owner_table_name = 'HZ_PARTY_SITES'

4180: p_contact_ids HZ_PARTY_SEARCH.IDList;
4181: l_match_idx NUMBER;
4182: cursor get_cpts_for_party_sites is select contact_point_id
4183: from hz_contact_points
4184: where owner_table_name = 'HZ_PARTY_SITES'
4185: and primary_flag='Y'
4186: and owner_table_id = p_party_site_id;
4187: BEGIN
4188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5570: FROM HZ_PARTY_SITES

5566: l_party_id := p_party_id;
5567: FOR PARTY_SITES IN (
5568: SELECT party_site_id FROM (
5569: SELECT party_site_id,identifying_address_flag
5570: FROM HZ_PARTY_SITES
5571: WHERE party_id = p_party_id
5572: AND (status is null OR status = 'A')
5573: AND identifying_address_flag='Y'
5574: UNION

Line 5577: FROM HZ_PARTY_SITES

5573: AND identifying_address_flag='Y'
5574: UNION
5575:
5576: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5577: FROM HZ_PARTY_SITES
5578: WHERE party_id = p_party_id
5579: AND (status is null OR status = 'A')
5580: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5581: AND ROWNUM<6

Line 5585: FROM HZ_PARTY_SITES

5581: AND ROWNUM<6
5582: UNION
5583:
5584: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5585: FROM HZ_PARTY_SITES
5586: WHERE (status is null OR status = 'A')
5587: AND party_id in (
5588: SELECT party_id
5589: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5625: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5621: AND ROWNUM<6
5622: UNION
5623:
5624: SELECT CONTACT_POINT_ID
5625: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5626: WHERE PRIMARY_FLAG = 'Y'
5627: AND owner_table_name = 'HZ_PARTY_SITES'
5628: AND owner_table_id = party_site_id
5629: AND PARTY_ID = p_party_id

Line 5627: AND owner_table_name = 'HZ_PARTY_SITES'

5623:
5624: SELECT CONTACT_POINT_ID
5625: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5626: WHERE PRIMARY_FLAG = 'Y'
5627: AND owner_table_name = 'HZ_PARTY_SITES'
5628: AND owner_table_id = party_site_id
5629: AND PARTY_ID = p_party_id
5630: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5631: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5764: ) IS
5765: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:
5772: I NUMBER;

Line 5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5765: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:
5772: I NUMBER;
5773: J NUMBER:=1;

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

5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:
5772: I NUMBER;
5773: J NUMBER:=1;
5774: l_party_site_id NUMBER;