Recursive relationship in oracle
I was able to get the output using below SQL

SQL&gt; SELECT  DISTINCT '402758970' CUS_ID,
  2                   REL_CUS_ID
  3    FROM  RELATED_TABLE
  4    START WITH CUS_ID = '402758970'
  5    CONNECT BY NOCYCLE PRIOR REL_CUS_ID = CUS_ID
  6  /

CUS_ID    REL_CUS_ID
--------- ---------
402758970 898196448
402758970 691094946
402758970 870397045
402758970 402758970
402758970 404636299
402758970 850353774
402758970 855115206