5231: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5232: INTO
5233: x_party_search_rec.PARTY_NAME
5234: ,x_party_search_rec.PARTY_TYPE
5235: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5236: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5237: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5238: AND HZ_PARTIES.party_id = p_party_id;
5239: ELSIF l_party_type = 'PERSON' THEN
5232: INTO
5233: x_party_search_rec.PARTY_NAME
5234: ,x_party_search_rec.PARTY_TYPE
5235: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5236: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5237: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5238: AND HZ_PARTIES.party_id = p_party_id;
5239: ELSIF l_party_type = 'PERSON' THEN
5240: SELECT
5233: x_party_search_rec.PARTY_NAME
5234: ,x_party_search_rec.PARTY_TYPE
5235: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5236: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5237: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5238: AND HZ_PARTIES.party_id = p_party_id;
5239: ELSIF l_party_type = 'PERSON' THEN
5240: SELECT
5241: translate(HZ_PARTIES.PARTY_NAME, '%',' ')