select distinct o1.OWNER
  from ALL_OBJECTS o1, ALL_OBJECTS o2, ALL_OBJECTS o3, ALL_OBJECTS o4
 where o1.OBJECT_NAME = 'PRA_POS_GAS'
   and o1.OBJECT_TYPE = 'PACKAGE'
   and o2.OBJECT_NAME = 'PRA_POS_PKA'
   and o2.OBJECT_TYPE = o1.OBJECT_TYPE
   and o2.OWNER = o1.OWNER
