SQL Query to find out the Component associated with a Component Interface

      SELECT BCPGNAME,MARKET,MENUNAME
       FROM PSBCDEFN
       WHERE BCNAME = 'XXXX_CI';