APPS.HZ_MATCH_RULE_8 dependencies on HZ_ORGANIZATION_PROFILES

Line 395: FROM HZ_ORGANIZATION_PROFILES

391: FROM HZ_PARTIES
392: WHERE party_id = p_record_id;
393: IF l_party_type = 'ORGANIZATION' THEN
394: SELECT DUNS_NUMBER_C INTO l_matched_value
395: FROM HZ_ORGANIZATION_PROFILES
396: WHERE party_id = p_record_id
397: and effective_end_date is null
398: and rownum = 1;
399: ELSIF l_party_type = 'PERSON' THEN

Line 401: FROM HZ_ORGANIZATION_PROFILES

397: and effective_end_date is null
398: and rownum = 1;
399: ELSIF l_party_type = 'PERSON' THEN
400: SELECT DUNS_NUMBER_C INTO l_matched_value
401: FROM HZ_ORGANIZATION_PROFILES
402: WHERE party_id = p_record_id
403: and rownum = 1;
404: END IF;
405: RETURN l_matched_value;

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

6111: 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);
6112: END IF;
6113: IF l_party_type = 'ORGANIZATION' THEN
6114: SELECT
6115: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6116: INTO
6117: x_party_search_rec.DUNS_NUMBER_C
6118: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6119: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

Line 6118: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6114: SELECT
6115: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6116: INTO
6117: x_party_search_rec.DUNS_NUMBER_C
6118: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6119: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6120: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6121: AND HZ_PARTIES.party_id = p_party_id;
6122: ELSIF l_party_type = 'PERSON' THEN

Line 6119: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6115: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
6116: INTO
6117: x_party_search_rec.DUNS_NUMBER_C
6118: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6119: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6120: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6121: AND HZ_PARTIES.party_id = p_party_id;
6122: ELSIF l_party_type = 'PERSON' THEN
6123: NULL;

Line 6120: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6116: INTO
6117: x_party_search_rec.DUNS_NUMBER_C
6118: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6119: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6120: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6121: AND HZ_PARTIES.party_id = p_party_id;
6122: ELSIF l_party_type = 'PERSON' THEN
6123: NULL;
6124: END IF;