how can i fetch in bip report parent position name and parent position code for a position code

Please Help Me!

Need to write a sql query for all the position details, in which i need to fetch parent position name and parent position code, how can i fetch that in bip report.