SQL to get Child Records

I want a list of PS_JOB's child record.

SELECT RECNAME 
FROM PSRECDEFN
CONNECT BY PRIOR RECNAME = PARENTRECNAME
START WITH PARENTRECNAME = 'Record Name Here';