APPS.HZ_MATCH_RULE_58 dependencies on HZ_ORGANIZATION_PROFILES

Line 366: FROM HZ_ORGANIZATION_PROFILES

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

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

5791: 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);
5792: END IF;
5793: IF l_party_type = 'ORGANIZATION' THEN
5794: SELECT
5795: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5796: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5797: INTO
5798: x_party_search_rec.JGZZ_FISCAL_CODE
5799: ,x_party_search_rec.PARTY_NUMBER

Line 5800: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5796: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5797: INTO
5798: x_party_search_rec.JGZZ_FISCAL_CODE
5799: ,x_party_search_rec.PARTY_NUMBER
5800: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5801: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5802: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5803: AND HZ_PARTIES.party_id = p_party_id;
5804: ELSIF l_party_type = 'PERSON' THEN

Line 5801: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5797: INTO
5798: x_party_search_rec.JGZZ_FISCAL_CODE
5799: ,x_party_search_rec.PARTY_NUMBER
5800: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5801: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5802: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5803: AND HZ_PARTIES.party_id = p_party_id;
5804: ELSIF l_party_type = 'PERSON' THEN
5805: SELECT

Line 5802: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5798: x_party_search_rec.JGZZ_FISCAL_CODE
5799: ,x_party_search_rec.PARTY_NUMBER
5800: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5801: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5802: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5803: AND HZ_PARTIES.party_id = p_party_id;
5804: ELSIF l_party_type = 'PERSON' THEN
5805: SELECT
5806: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')