5941: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5942: INTO
5943: x_party_search_rec.PARTY_NUMBER
5944: ,x_party_search_rec.PARTY_TYPE
5945: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5946: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5947: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5948: AND HZ_PARTIES.party_id = p_party_id;
5949: ELSIF l_party_type = 'PERSON' THEN
5942: INTO
5943: x_party_search_rec.PARTY_NUMBER
5944: ,x_party_search_rec.PARTY_TYPE
5945: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5946: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5947: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5948: AND HZ_PARTIES.party_id = p_party_id;
5949: ELSIF l_party_type = 'PERSON' THEN
5950: SELECT
5943: x_party_search_rec.PARTY_NUMBER
5944: ,x_party_search_rec.PARTY_TYPE
5945: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5946: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5947: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5948: AND HZ_PARTIES.party_id = p_party_id;
5949: ELSIF l_party_type = 'PERSON' THEN
5950: SELECT
5951: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')