APPS.HZ_MATCH_RULE_3 dependencies on HZ_ORGANIZATION_PROFILES

Line 291: FROM HZ_ORGANIZATION_PROFILES

287: FROM HZ_PARTIES
288: WHERE party_id = p_record_id;
289: IF l_party_type = 'ORGANIZATION' THEN
290: SELECT TAX_REFERENCE INTO l_matched_value
291: FROM HZ_ORGANIZATION_PROFILES
292: WHERE party_id = p_record_id
293: and effective_end_date is null
294: and rownum = 1;
295: ELSIF l_party_type = 'PERSON' THEN

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

5283: END IF;
5284: IF l_party_type = 'ORGANIZATION' THEN
5285: SELECT
5286: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5287: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5288: INTO
5289: x_party_search_rec.PARTY_TYPE
5290: ,x_party_search_rec.TAX_REFERENCE
5291: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

Line 5291: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5287: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5288: INTO
5289: x_party_search_rec.PARTY_TYPE
5290: ,x_party_search_rec.TAX_REFERENCE
5291: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5292: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5293: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5294: AND HZ_PARTIES.party_id = p_party_id;
5295: ELSIF l_party_type = 'PERSON' THEN

Line 5292: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5288: INTO
5289: x_party_search_rec.PARTY_TYPE
5290: ,x_party_search_rec.TAX_REFERENCE
5291: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5292: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5293: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5294: AND HZ_PARTIES.party_id = p_party_id;
5295: ELSIF l_party_type = 'PERSON' THEN
5296: SELECT

Line 5293: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5289: x_party_search_rec.PARTY_TYPE
5290: ,x_party_search_rec.TAX_REFERENCE
5291: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5292: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5293: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5294: AND HZ_PARTIES.party_id = p_party_id;
5295: ELSIF l_party_type = 'PERSON' THEN
5296: SELECT
5297: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')