APPS.HZ_MATCH_RULE_2 dependencies on HZ_ORGANIZATION_PROFILES

Line 300: FROM HZ_ORGANIZATION_PROFILES

296: FROM HZ_PARTIES
297: WHERE party_id = p_record_id;
298: IF l_party_type = 'ORGANIZATION' THEN
299: SELECT DUNS_NUMBER_C INTO l_matched_value
300: FROM HZ_ORGANIZATION_PROFILES
301: WHERE party_id = p_record_id
302: and effective_end_date is null
303: and rownum = 1;
304: ELSIF l_party_type = 'PERSON' THEN

Line 306: FROM HZ_ORGANIZATION_PROFILES

302: and effective_end_date is null
303: and rownum = 1;
304: ELSIF l_party_type = 'PERSON' THEN
305: SELECT DUNS_NUMBER_C INTO l_matched_value
306: FROM HZ_ORGANIZATION_PROFILES
307: WHERE party_id = p_record_id
308: and rownum = 1;
309: END IF;
310: RETURN l_matched_value;

Line 319: FROM HZ_ORGANIZATION_PROFILES

315: FROM HZ_PARTIES
316: WHERE party_id = p_record_id;
317: IF l_party_type = 'ORGANIZATION' THEN
318: SELECT TAX_REFERENCE INTO l_matched_value
319: FROM HZ_ORGANIZATION_PROFILES
320: WHERE party_id = p_record_id
321: and effective_end_date is null
322: and rownum = 1;
323: ELSIF l_party_type = 'PERSON' THEN

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

5330: 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);
5331: END IF;
5332: IF l_party_type = 'ORGANIZATION' THEN
5333: SELECT
5334: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5335: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5336: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5337: INTO
5338: x_party_search_rec.DUNS_NUMBER_C

Line 5336: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

5332: IF l_party_type = 'ORGANIZATION' THEN
5333: SELECT
5334: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5335: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5336: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5337: INTO
5338: x_party_search_rec.DUNS_NUMBER_C
5339: ,x_party_search_rec.PARTY_TYPE
5340: ,x_party_search_rec.TAX_REFERENCE

Line 5341: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5337: INTO
5338: x_party_search_rec.DUNS_NUMBER_C
5339: ,x_party_search_rec.PARTY_TYPE
5340: ,x_party_search_rec.TAX_REFERENCE
5341: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5342: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5343: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5344: AND HZ_PARTIES.party_id = p_party_id;
5345: ELSIF l_party_type = 'PERSON' THEN

Line 5342: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5338: x_party_search_rec.DUNS_NUMBER_C
5339: ,x_party_search_rec.PARTY_TYPE
5340: ,x_party_search_rec.TAX_REFERENCE
5341: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5342: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5343: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5344: AND HZ_PARTIES.party_id = p_party_id;
5345: ELSIF l_party_type = 'PERSON' THEN
5346: SELECT

Line 5343: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5339: ,x_party_search_rec.PARTY_TYPE
5340: ,x_party_search_rec.TAX_REFERENCE
5341: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5342: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5343: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5344: AND HZ_PARTIES.party_id = p_party_id;
5345: ELSIF l_party_type = 'PERSON' THEN
5346: SELECT
5347: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')