SQL query to get the manager of a particular department in bip report in fusion

I need to get a BIP report that should contains person information and department , Department hierarchy till level 3 including top department and the manager's name of every department level , I am able to get the Department hierarchy but manager's name of every department level are not consistent for all records because in query I am joining per_manager_hrchy_dn with assignment_id of cmp_cwb_person_info_v table. cmp_cwb_person_info_v table is picking the old assignment which is end dated as bold condition which is mentioned in below query does not satisfied and getting no record , If I remove this condition getting