SQL Queries - CAST Knowledge Base - Queries on Module - How to check if ghost objects are part of any module

SELECT sq.module_name 
FROM   <local_base>.cdt_objects cobj 
JOIN 
       ( 
              SELECT pso.object_id  AS object_id , 
                     ps.module_name AS module_name 
              FROM   <local_base>.pmc_subset_objects pso 
              JOIN 
                     ( 
                            SELECT ps.subset_id   AS module_id, 
                                   pm.object_name AS module_name 
                            FROM   ( 
                                          SELECT pm.object_id, 
                                                 pm.object_name 
                                          FROM   <mngt_base>.cms_portf_module pm ) pm 
                            JOIN   <local_base>.pmc_subsets ps 
                            ON     ps.subset_name LIKE 'CMS_MOD__' 
                                          || pm.object_id 
                                          || '_Preparation2' ) ps 
              ON     pso.subset_id = ps.module_id ) sq 
ON     sq.object_id = cobj.object_id 
WHERE  cobj.object_id IN 
       ( -- This is the list of Ghost objects
                SELECT   k.idkey 
                FROM     <local_base>.keys k 
                JOIN     <local_base>.typ t 
                ON       t.idtyp = k.objtyp 
                JOIN     <local_base>.typcat tc 
                ON       tc.idtyp = t.idtyp 
                AND      tc.idcatparent = 2500 
                WHERE    k.objtyp NOT IN (237, 
                                          355) 
                AND      NOT EXISTS 
                         ( 
                                SELECT 1 
                                FROM   <local_base>.objpro op 
                                WHERE  op.idobj = k.idkey) 
                ORDER BY k.idkey)