6346: SELECT
6347: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6348: INTO
6349: x_party_search_rec.PARTY_NUMBER
6350: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6351: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6352: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6353: AND HZ_PARTIES.party_id = p_party_id;
6354: ELSIF l_party_type = 'PERSON' THEN
6347: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6348: INTO
6349: x_party_search_rec.PARTY_NUMBER
6350: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6351: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6352: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6353: AND HZ_PARTIES.party_id = p_party_id;
6354: ELSIF l_party_type = 'PERSON' THEN
6355: SELECT
6348: INTO
6349: x_party_search_rec.PARTY_NUMBER
6350: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6351: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6352: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6353: AND HZ_PARTIES.party_id = p_party_id;
6354: ELSIF l_party_type = 'PERSON' THEN
6355: SELECT
6356: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')