Need help on a query with Account hierarchies

Summary:

I need to retrieve GL balances based on the account hierarchies and I am not able to get it for the 2nd level child. I am able to do it for one level. In the query below, the parent value 80000 has a couple of parents in it and I need to get to the lowest level child value. Can you pelase help?

select pk1_value from GL_SEG_VAL_HIER_RF

where tree_code = 'Account SPWR US CORPORATE'

and distance = 1

and ANCESTOR_PK1_VALUE in ('80000', '85000') 

and tree_version_id = 'BEF811F07D6DC7F8E0534461500A0B3F'