select impl_id
from acs_sc_impls
where impl_owner_name = :owner
and impl_name = :name
select impl_id
from acs_sc_impls
where impl_owner_name = :owner
and impl_name = :name
and impl_contract_name = :contract
select impl_name,
impl_pretty_name,
impl_owner_name,
impl_contract_name
from acs_sc_impls
where impl_id = :impl_id