Oracle Apps : Query to get the Position details of an employee in R12.1.3

The below query gives the details of an employee's current position in Oracle Apps R12.1.3.

 SELECT papf.person_id  
       ,papf.full_name  
       ,hapf.name                  position  
       ,papf.effective_start_date  employee_start_date  
       ,papf.effective_end_date    employee_end_date  
       ,asg.effective_start_date   assignment_start_date  
       ,asg.effective_end_date     assignment_end_date  
 FROM  per_all_people_f       papf  
      ,per_all_assignments_f  asg  
      ,hr_all_positions_f     hapf  
 WHERE papf.person_id = asg.person_id(+)  
 AND   SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date  
 AND   SYSDATE BETWEEN asg.effective_start_date  AND asg.effective_end_date  
 AND   SYSDATE BETWEEN hapf.effective_start_date AND hapf.effective_end_date  
 AND   asg.position_id = hapf.position_id  
 AND   UPPER(papf.full_name) LIKE UPPER('%Anoop%')  
 ORDER BY papf.full_name;  

Feel free to point out if anything is missing/wrong in this blog.