5226: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5227: INTO
5228: x_party_search_rec.PARTY_NAME
5229: ,x_party_search_rec.PARTY_TYPE
5230: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5231: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5232: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5233: AND HZ_PARTIES.party_id = p_party_id;
5234: ELSIF l_party_type = 'PERSON' THEN
5227: INTO
5228: x_party_search_rec.PARTY_NAME
5229: ,x_party_search_rec.PARTY_TYPE
5230: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5231: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5232: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5233: AND HZ_PARTIES.party_id = p_party_id;
5234: ELSIF l_party_type = 'PERSON' THEN
5235: SELECT
5228: x_party_search_rec.PARTY_NAME
5229: ,x_party_search_rec.PARTY_TYPE
5230: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5231: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5232: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5233: AND HZ_PARTIES.party_id = p_party_id;
5234: ELSIF l_party_type = 'PERSON' THEN
5235: SELECT
5236: translate(HZ_PARTIES.PARTY_NAME, '%',' ')