APPS.HZ_MATCH_RULE_39 dependencies on HZ_PARTY_SITES

Line 4006: where owner_table_name = 'HZ_PARTY_SITES'

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

Line 5338: FROM HZ_PARTY_SITES

5334: l_party_id := p_party_id;
5335: FOR PARTY_SITES IN (
5336: SELECT party_site_id FROM (
5337: SELECT party_site_id,identifying_address_flag
5338: FROM HZ_PARTY_SITES
5339: WHERE party_id = p_party_id
5340: AND (status is null OR status = 'A')
5341: AND identifying_address_flag='Y'
5342: UNION

Line 5345: FROM HZ_PARTY_SITES

5341: AND identifying_address_flag='Y'
5342: UNION
5343:
5344: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5345: FROM HZ_PARTY_SITES
5346: WHERE party_id = p_party_id
5347: AND (status is null OR status = 'A')
5348: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5349: AND ROWNUM<6

Line 5353: FROM HZ_PARTY_SITES

5349: AND ROWNUM<6
5350: UNION
5351:
5352: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5353: FROM HZ_PARTY_SITES
5354: WHERE (status is null OR status = 'A')
5355: AND party_id in (
5356: SELECT party_id
5357: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5502: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5498: ) IS
5499: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5500: SELECT party_site_id
5501: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5502: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5503: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5504: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5505:
5506: I NUMBER;

Line 5503: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5499: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5500: SELECT party_site_id
5501: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5502: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5503: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5504: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5505:
5506: I NUMBER;
5507: J NUMBER:=1;

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

5500: SELECT party_site_id
5501: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5502: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5503: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5504: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5505:
5506: I NUMBER;
5507: J NUMBER:=1;
5508: l_party_site_id NUMBER;