6357: SELECT
6358: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6359: INTO
6360: x_party_search_rec.PARTY_NUMBER
6361: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6362: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6363: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6364: AND HZ_PARTIES.party_id = p_party_id;
6365: ELSIF l_party_type = 'PERSON' THEN
6358: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6359: INTO
6360: x_party_search_rec.PARTY_NUMBER
6361: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6362: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6363: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6364: AND HZ_PARTIES.party_id = p_party_id;
6365: ELSIF l_party_type = 'PERSON' THEN
6366: SELECT
6359: INTO
6360: x_party_search_rec.PARTY_NUMBER
6361: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6362: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6363: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6364: AND HZ_PARTIES.party_id = p_party_id;
6365: ELSIF l_party_type = 'PERSON' THEN
6366: SELECT
6367: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')