4242: decode(ROAD_NAME, null, rtrim(CITY_PROVINCE||' '||DISTRICT||' '||TOWN_VILLAGE||' '||HOUSE_NUMBER),
4243: RTRIM(CITY_PROVINCE||' '||DISTRICT||' '||TOWN_VILLAGE||' '||ROAD_NAME||' '||HOUSE_NUMBER||' '||
4244: decode((LEGISLATIVE_DISTRICT || PUBLIC_HOUSING_NAME) , null, ' ', '('||LEGISLATIVE_DISTRICT ||
4245: decode(LEGISLATIVE_DISTRICT, null, PUBLIC_HOUSING_NAME,decode(PUBLIC_HOUSING_NAME, null, null,', '||PUBLIC_HOUSING_NAME)) || ')' )))
4246: from per_kr_addresses
4247: where postal_code_id = l_postal_code_id;
4248: --
4249: begin
4250: --