385: FROM HZ_PARTIES
386: WHERE party_id = p_record_id;
387: IF l_party_type = 'ORGANIZATION' THEN
388: SELECT DUNS_NUMBER_C INTO l_matched_value
389: FROM HZ_ORGANIZATION_PROFILES
390: WHERE party_id = p_record_id
391: and effective_end_date is null
392: and rownum = 1;
393: ELSIF l_party_type = 'PERSON' THEN
391: and effective_end_date is null
392: and rownum = 1;
393: ELSIF l_party_type = 'PERSON' THEN
394: SELECT DUNS_NUMBER_C INTO l_matched_value
395: FROM HZ_ORGANIZATION_PROFILES
396: WHERE party_id = p_record_id
397: and rownum = 1;
398: END IF;
399: RETURN l_matched_value;
404: FROM HZ_PARTIES
405: WHERE party_id = p_record_id;
406: IF l_party_type = 'ORGANIZATION' THEN
407: SELECT TAX_REFERENCE INTO l_matched_value
408: FROM HZ_ORGANIZATION_PROFILES
409: WHERE party_id = p_record_id
410: and effective_end_date is null
411: and rownum = 1;
412: ELSIF l_party_type = 'PERSON' THEN
424: FROM HZ_PARTIES
425: WHERE party_id = p_record_id;
426: IF l_party_type = 'ORGANIZATION' THEN
427: SELECT SIC_CODE INTO l_matched_value
428: FROM HZ_ORGANIZATION_PROFILES
429: WHERE party_id = p_record_id
430: and effective_end_date is null
431: and rownum = 1;
432: ELSIF l_party_type = 'PERSON' THEN
430: and effective_end_date is null
431: and rownum = 1;
432: ELSIF l_party_type = 'PERSON' THEN
433: SELECT SIC_CODE INTO l_matched_value
434: FROM HZ_ORGANIZATION_PROFILES
435: WHERE party_id = p_record_id
436: and rownum = 1;
437: END IF;
438: RETURN l_matched_value;
5799: hz_utility_v2pub.debug(p_message=>'l_party_type is - '||l_party_type,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5800: END IF;
5801: IF l_party_type = 'ORGANIZATION' THEN
5802: SELECT
5803: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5804: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5805: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5806: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5807: INTO
5801: IF l_party_type = 'ORGANIZATION' THEN
5802: SELECT
5803: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5804: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5805: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5806: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5807: INTO
5808: x_party_search_rec.DUNS_NUMBER_C
5809: ,x_party_search_rec.PARTY_NAME
5802: SELECT
5803: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5804: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5805: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5806: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5807: INTO
5808: x_party_search_rec.DUNS_NUMBER_C
5809: ,x_party_search_rec.PARTY_NAME
5810: ,x_party_search_rec.SIC_CODE
5808: x_party_search_rec.DUNS_NUMBER_C
5809: ,x_party_search_rec.PARTY_NAME
5810: ,x_party_search_rec.SIC_CODE
5811: ,x_party_search_rec.TAX_REFERENCE
5812: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5813: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5814: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5815: AND HZ_PARTIES.party_id = p_party_id;
5816: ELSIF l_party_type = 'PERSON' THEN
5809: ,x_party_search_rec.PARTY_NAME
5810: ,x_party_search_rec.SIC_CODE
5811: ,x_party_search_rec.TAX_REFERENCE
5812: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5813: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5814: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5815: AND HZ_PARTIES.party_id = p_party_id;
5816: ELSIF l_party_type = 'PERSON' THEN
5817: SELECT
5810: ,x_party_search_rec.SIC_CODE
5811: ,x_party_search_rec.TAX_REFERENCE
5812: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5813: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5814: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5815: AND HZ_PARTIES.party_id = p_party_id;
5816: ELSIF l_party_type = 'PERSON' THEN
5817: SELECT
5818: translate(HZ_PARTIES.PARTY_NAME, '%',' ')