APPS.HZ_MATCH_RULE_48 dependencies on HZ_PARTY_SITES

Line 424: FROM HZ_PARTY_SITES, HZ_LOCATIONS

420: IF p_attribute = 'CITY' THEN
421: BEGIN
422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN

Line 425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

421: BEGIN
422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: l_matched_value := 'Err';

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

422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: l_matched_value := 'Err';
430: END;

Line 437: FROM HZ_PARTY_SITES, HZ_LOCATIONS

433: IF p_attribute = 'STATE' THEN
434: BEGIN
435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN

Line 438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

434: BEGIN
435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: l_matched_value := 'Err';

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

435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: l_matched_value := 'Err';
443: END;

Line 450: FROM HZ_PARTY_SITES, HZ_LOCATIONS

446: IF p_attribute = 'COUNTRY' THEN
447: BEGIN
448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN

Line 451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

447: BEGIN
448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: l_matched_value := 'Err';

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

448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: l_matched_value := 'Err';
456: END;

Line 4216: where owner_table_name = 'HZ_PARTY_SITES'

4212: p_contact_ids HZ_PARTY_SEARCH.IDList;
4213: l_match_idx NUMBER;
4214: cursor get_cpts_for_party_sites is select contact_point_id
4215: from hz_contact_points
4216: where owner_table_name = 'HZ_PARTY_SITES'
4217: and primary_flag='Y'
4218: and owner_table_id = p_party_site_id;
4219: BEGIN
4220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5573: FROM HZ_PARTY_SITES

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

Line 5580: FROM HZ_PARTY_SITES

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

Line 5588: FROM HZ_PARTY_SITES

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

Line 5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5737: SELECT party_site_id
5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;

Line 5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;
5746: J NUMBER:=1;

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

5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;
5746: J NUMBER:=1;
5747: l_party_site_id NUMBER;