APPS.HZ_MATCH_RULE_61 dependencies on HZ_ORGANIZATION_PROFILES

Line 360: FROM HZ_ORGANIZATION_PROFILES

356: FROM HZ_PARTIES
357: WHERE party_id = p_record_id;
358: IF l_party_type = 'ORGANIZATION' THEN
359: SELECT DUNS_NUMBER_C INTO l_matched_value
360: FROM HZ_ORGANIZATION_PROFILES
361: WHERE party_id = p_record_id
362: and effective_end_date is null
363: and rownum = 1;
364: ELSIF l_party_type = 'PERSON' THEN

Line 366: FROM HZ_ORGANIZATION_PROFILES

362: and effective_end_date is null
363: and rownum = 1;
364: ELSIF l_party_type = 'PERSON' THEN
365: SELECT DUNS_NUMBER_C INTO l_matched_value
366: FROM HZ_ORGANIZATION_PROFILES
367: WHERE party_id = p_record_id
368: and rownum = 1;
369: END IF;
370: RETURN l_matched_value;

Line 379: FROM HZ_ORGANIZATION_PROFILES

375: FROM HZ_PARTIES
376: WHERE party_id = p_record_id;
377: IF l_party_type = 'ORGANIZATION' THEN
378: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
379: FROM HZ_ORGANIZATION_PROFILES
380: WHERE party_id = p_record_id
381: and effective_end_date is null
382: and rownum = 1;
383: ELSIF l_party_type = 'PERSON' THEN

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

5695: 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);
5696: END IF;
5697: IF l_party_type = 'ORGANIZATION' THEN
5698: SELECT
5699: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5700: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5701: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5702: INTO
5703: x_party_search_rec.DUNS_NUMBER_C

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

5696: END IF;
5697: IF l_party_type = 'ORGANIZATION' THEN
5698: SELECT
5699: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5700: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5701: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5702: INTO
5703: x_party_search_rec.DUNS_NUMBER_C
5704: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 5706: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5702: INTO
5703: x_party_search_rec.DUNS_NUMBER_C
5704: ,x_party_search_rec.JGZZ_FISCAL_CODE
5705: ,x_party_search_rec.PARTY_NUMBER
5706: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5707: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5708: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5709: AND HZ_PARTIES.party_id = p_party_id;
5710: ELSIF l_party_type = 'PERSON' THEN

Line 5707: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5703: x_party_search_rec.DUNS_NUMBER_C
5704: ,x_party_search_rec.JGZZ_FISCAL_CODE
5705: ,x_party_search_rec.PARTY_NUMBER
5706: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5707: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5708: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5709: AND HZ_PARTIES.party_id = p_party_id;
5710: ELSIF l_party_type = 'PERSON' THEN
5711: SELECT

Line 5708: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5704: ,x_party_search_rec.JGZZ_FISCAL_CODE
5705: ,x_party_search_rec.PARTY_NUMBER
5706: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5707: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5708: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5709: AND HZ_PARTIES.party_id = p_party_id;
5710: ELSIF l_party_type = 'PERSON' THEN
5711: SELECT
5712: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')