APPS.HZ_MATCH_RULE_62 dependencies on HZ_ORGANIZATION_PROFILES

Line 425: FROM HZ_ORGANIZATION_PROFILES

421: FROM HZ_PARTIES
422: WHERE party_id = p_record_id;
423: IF l_party_type = 'ORGANIZATION' THEN
424: SELECT DUNS_NUMBER_C INTO l_matched_value
425: FROM HZ_ORGANIZATION_PROFILES
426: WHERE party_id = p_record_id
427: and effective_end_date is null
428: and rownum = 1;
429: ELSIF l_party_type = 'PERSON' THEN

Line 431: FROM HZ_ORGANIZATION_PROFILES

427: and effective_end_date is null
428: and rownum = 1;
429: ELSIF l_party_type = 'PERSON' THEN
430: SELECT DUNS_NUMBER_C INTO l_matched_value
431: FROM HZ_ORGANIZATION_PROFILES
432: WHERE party_id = p_record_id
433: and rownum = 1;
434: END IF;
435: RETURN l_matched_value;

Line 467: FROM HZ_ORGANIZATION_PROFILES

463: FROM HZ_PARTIES
464: WHERE party_id = p_record_id;
465: IF l_party_type = 'ORGANIZATION' THEN
466: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
467: FROM HZ_ORGANIZATION_PROFILES
468: WHERE party_id = p_record_id
469: and effective_end_date is null
470: and rownum = 1;
471: ELSIF l_party_type = 'PERSON' THEN

Line 6358: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')

6354: 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);
6355: END IF;
6356: IF l_party_type = 'ORGANIZATION' THEN
6357: SELECT
6358: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6359: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6360: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6361: INTO
6362: x_party_search_rec.DUNS_NUMBER_C

Line 6359: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

6355: END IF;
6356: IF l_party_type = 'ORGANIZATION' THEN
6357: SELECT
6358: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6359: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6360: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6361: INTO
6362: x_party_search_rec.DUNS_NUMBER_C
6363: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 6365: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6361: INTO
6362: x_party_search_rec.DUNS_NUMBER_C
6363: ,x_party_search_rec.JGZZ_FISCAL_CODE
6364: ,x_party_search_rec.PARTY_NUMBER
6365: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6366: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6367: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6368: AND HZ_PARTIES.party_id = p_party_id;
6369: ELSIF l_party_type = 'PERSON' THEN

Line 6366: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6362: x_party_search_rec.DUNS_NUMBER_C
6363: ,x_party_search_rec.JGZZ_FISCAL_CODE
6364: ,x_party_search_rec.PARTY_NUMBER
6365: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6366: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6367: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6368: AND HZ_PARTIES.party_id = p_party_id;
6369: ELSIF l_party_type = 'PERSON' THEN
6370: SELECT

Line 6367: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6363: ,x_party_search_rec.JGZZ_FISCAL_CODE
6364: ,x_party_search_rec.PARTY_NUMBER
6365: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6366: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6367: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6368: AND HZ_PARTIES.party_id = p_party_id;
6369: ELSIF l_party_type = 'PERSON' THEN
6370: SELECT
6371: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')