APPS.HZ_MATCH_RULE_35 dependencies on HZ_PARTY_SITES

Line 427: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 428: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 440: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 441: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 453: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 454: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 4362: where owner_table_name = 'HZ_PARTY_SITES'

4358: p_contact_ids HZ_PARTY_SEARCH.IDList;
4359: l_match_idx NUMBER;
4360: cursor get_cpts_for_party_sites is select contact_point_id
4361: from hz_contact_points
4362: where owner_table_name = 'HZ_PARTY_SITES'
4363: and primary_flag='Y'
4364: and owner_table_id = p_party_site_id;
4365: BEGIN
4366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5729: FROM HZ_PARTY_SITES

5725: l_party_id := p_party_id;
5726: FOR PARTY_SITES IN (
5727: SELECT party_site_id FROM (
5728: SELECT party_site_id,identifying_address_flag
5729: FROM HZ_PARTY_SITES
5730: WHERE party_id = p_party_id
5731: AND (status is null OR status = 'A')
5732: AND identifying_address_flag='Y'
5733: UNION

Line 5736: FROM HZ_PARTY_SITES

5732: AND identifying_address_flag='Y'
5733: UNION
5734:
5735: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5736: FROM HZ_PARTY_SITES
5737: WHERE party_id = p_party_id
5738: AND (status is null OR status = 'A')
5739: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5740: AND ROWNUM<6

Line 5744: FROM HZ_PARTY_SITES

5740: AND ROWNUM<6
5741: UNION
5742:
5743: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5744: FROM HZ_PARTY_SITES
5745: WHERE (status is null OR status = 'A')
5746: AND party_id in (
5747: SELECT party_id
5748: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5891: SELECT party_site_id
5892: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5893: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5894: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:
5899: I NUMBER;

Line 5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5892: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5893: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5894: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:
5899: I NUMBER;
5900: J NUMBER:=1;

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

5893: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5894: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:
5899: I NUMBER;
5900: J NUMBER:=1;
5901: l_party_site_id NUMBER;