APPS.HZ_MATCH_RULE_39 dependencies on HZ_PARTY_SITES

Line 4010: where owner_table_name = 'HZ_PARTY_SITES'

4006: p_contact_ids HZ_PARTY_SEARCH.IDList;
4007: l_match_idx NUMBER;
4008: cursor get_cpts_for_party_sites is select contact_point_id
4009: from hz_contact_points
4010: where owner_table_name = 'HZ_PARTY_SITES'
4011: and primary_flag='Y'
4012: and owner_table_id = p_party_site_id;
4013: BEGIN
4014: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5343: FROM HZ_PARTY_SITES

5339: l_party_id := p_party_id;
5340: FOR PARTY_SITES IN (
5341: SELECT party_site_id FROM (
5342: SELECT party_site_id,identifying_address_flag
5343: FROM HZ_PARTY_SITES
5344: WHERE party_id = p_party_id
5345: AND (status is null OR status = 'A')
5346: AND identifying_address_flag='Y'
5347: UNION

Line 5350: FROM HZ_PARTY_SITES

5346: AND identifying_address_flag='Y'
5347: UNION
5348:
5349: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5350: FROM HZ_PARTY_SITES
5351: WHERE party_id = p_party_id
5352: AND (status is null OR status = 'A')
5353: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5354: AND ROWNUM<6

Line 5358: FROM HZ_PARTY_SITES

5354: AND ROWNUM<6
5355: UNION
5356:
5357: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5358: FROM HZ_PARTY_SITES
5359: WHERE (status is null OR status = 'A')
5360: AND party_id in (
5361: SELECT party_id
5362: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5507: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5503: ) IS
5504: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5505: SELECT party_site_id
5506: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5507: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5508: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5509: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5510:
5511: I NUMBER;

Line 5508: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5504: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5505: SELECT party_site_id
5506: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5507: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5508: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5509: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5510:
5511: I NUMBER;
5512: J NUMBER:=1;

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

5505: SELECT party_site_id
5506: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5507: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5508: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5509: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5510:
5511: I NUMBER;
5512: J NUMBER:=1;
5513: l_party_site_id NUMBER;