Suppose I have a table PERSON as follows

PERSON
---------
ID -> PK
NAME
REF_ID
PARENT_REF_ID

with the sample data as follows

ID-----NAME-----REF_ID-----PARENT_REF_ID
100----A----------200---------NULL (If null then it is the root/parent record)
101----B----------201---------200 (Refers to A)
102----C----------202---------201 (Refers to B)
103----D----------203---------202 (Refers to C)
104----E----------204---------200 (Refers to A)

And the parent child relationship between the records by self join is as follows
A -> B -> C -> D
A -> E

Can anyone please tell me if we can acheive this parent-child heirarchy relationship using creiteria and how?