select sp.k, sp.p_k
        from SSP sp
          inner join SPP rn_
            on (sp.rayon=rn_.kod) and
                (upper(rn_.name)=:OUT_RAYON)
          inner join SPP np_
            on (sp.naspunkt=np_.kod) and
                (upper(np_.name)=:TMP_S)
          inner join SPP ul_
            on (sp.ul=ul_.kod) and
                (upper(ul_.name)=:OUT_ULICA)
        where (upper(sp.dom)=:OUT_DOM) and
                 (upper(sp.kv)=:OUT_KVARTIRA) and
                 (upper(sp.korpus)=:OUT_KORPUS)
        into :OUT_KODSPR, :OUT_PLAT_KOD;