APPS.HZ_MATCH_RULE_60 dependencies on HZ_ORGANIZATION_PROFILES

Line 446: FROM HZ_ORGANIZATION_PROFILES

442: FROM HZ_PARTIES
443: WHERE party_id = p_record_id;
444: IF l_party_type = 'ORGANIZATION' THEN
445: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
446: FROM HZ_ORGANIZATION_PROFILES
447: WHERE party_id = p_record_id
448: and effective_end_date is null
449: and rownum = 1;
450: ELSIF l_party_type = 'PERSON' THEN

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

6376: 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);
6377: END IF;
6378: IF l_party_type = 'ORGANIZATION' THEN
6379: SELECT
6380: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6381: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6382: INTO
6383: x_party_search_rec.JGZZ_FISCAL_CODE
6384: ,x_party_search_rec.PARTY_NUMBER

Line 6385: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6381: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6382: INTO
6383: x_party_search_rec.JGZZ_FISCAL_CODE
6384: ,x_party_search_rec.PARTY_NUMBER
6385: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6386: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6387: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6388: AND HZ_PARTIES.party_id = p_party_id;
6389: ELSIF l_party_type = 'PERSON' THEN

Line 6386: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6382: INTO
6383: x_party_search_rec.JGZZ_FISCAL_CODE
6384: ,x_party_search_rec.PARTY_NUMBER
6385: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6386: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6387: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6388: AND HZ_PARTIES.party_id = p_party_id;
6389: ELSIF l_party_type = 'PERSON' THEN
6390: SELECT

Line 6387: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6383: x_party_search_rec.JGZZ_FISCAL_CODE
6384: ,x_party_search_rec.PARTY_NUMBER
6385: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6386: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6387: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6388: AND HZ_PARTIES.party_id = p_party_id;
6389: ELSIF l_party_type = 'PERSON' THEN
6390: SELECT
6391: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')