SQL query to get all the child records for a parent record:

    SELECT RECNAME FROM PSRECDEFN
    CONNECT BY PRIOR RECNAME=PARENTRECNAME
      START WITH PARENTRECNAME = 'PS_JOB';