APPS.HZ_MATCH_RULE_4 dependencies on HZ_PARTY_SITES

Line 3918: where owner_table_name = 'HZ_PARTY_SITES'

3914: p_contact_ids HZ_PARTY_SEARCH.IDList;
3915: l_match_idx NUMBER;
3916: cursor get_cpts_for_party_sites is select contact_point_id
3917: from hz_contact_points
3918: where owner_table_name = 'HZ_PARTY_SITES'
3919: and primary_flag='Y'
3920: and owner_table_id = p_party_site_id;
3921: BEGIN
3922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5251: FROM HZ_PARTY_SITES

5247: l_party_id := p_party_id;
5248: FOR PARTY_SITES IN (
5249: SELECT party_site_id FROM (
5250: SELECT party_site_id,identifying_address_flag
5251: FROM HZ_PARTY_SITES
5252: WHERE party_id = p_party_id
5253: AND (status is null OR status = 'A')
5254: AND identifying_address_flag='Y'
5255: UNION

Line 5258: FROM HZ_PARTY_SITES

5254: AND identifying_address_flag='Y'
5255: UNION
5256:
5257: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5258: FROM HZ_PARTY_SITES
5259: WHERE party_id = p_party_id
5260: AND (status is null OR status = 'A')
5261: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5262: AND ROWNUM<6

Line 5266: FROM HZ_PARTY_SITES

5262: AND ROWNUM<6
5263: UNION
5264:
5265: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5266: FROM HZ_PARTY_SITES
5267: WHERE (status is null OR status = 'A')
5268: AND party_id in (
5269: SELECT party_id
5270: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5417: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5413: ) IS
5414: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5415: SELECT party_site_id
5416: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5417: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5418: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5419: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5420:
5421: I NUMBER;

Line 5418: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5414: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5415: SELECT party_site_id
5416: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5417: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5418: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5419: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5420:
5421: I NUMBER;
5422: J NUMBER:=1;

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

5415: SELECT party_site_id
5416: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5417: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5418: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5419: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5420:
5421: I NUMBER;
5422: J NUMBER:=1;
5423: l_party_site_id NUMBER;