APPS.HZ_MATCH_RULE_53 dependencies on HZ_ORGANIZATION_PROFILES

Line 422: FROM HZ_ORGANIZATION_PROFILES

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

Line 428: FROM HZ_ORGANIZATION_PROFILES

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

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

6005: 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);
6006: END IF;
6007: IF l_party_type = 'ORGANIZATION' THEN
6008: SELECT
6009: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6010: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6011: INTO
6012: x_party_search_rec.DUNS_NUMBER_C
6013: ,x_party_search_rec.PARTY_NUMBER

Line 6014: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6010: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6011: INTO
6012: x_party_search_rec.DUNS_NUMBER_C
6013: ,x_party_search_rec.PARTY_NUMBER
6014: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6015: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6016: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6017: AND HZ_PARTIES.party_id = p_party_id;
6018: ELSIF l_party_type = 'PERSON' THEN

Line 6015: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6011: INTO
6012: x_party_search_rec.DUNS_NUMBER_C
6013: ,x_party_search_rec.PARTY_NUMBER
6014: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6015: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6016: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6017: AND HZ_PARTIES.party_id = p_party_id;
6018: ELSIF l_party_type = 'PERSON' THEN
6019: SELECT

Line 6016: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6012: x_party_search_rec.DUNS_NUMBER_C
6013: ,x_party_search_rec.PARTY_NUMBER
6014: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6015: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6016: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6017: AND HZ_PARTIES.party_id = p_party_id;
6018: ELSIF l_party_type = 'PERSON' THEN
6019: SELECT
6020: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')